1.) I definately would create a new SQL user for Shelby Center...That would
be the most secure way to deploy ShelbyCenter. And yes you can define
certain access for each database login, though it is a pain ;-)
2.) I would caution you against replicating your database to an external SQL
Server, first off because that SQL server is probably on the internet and
more susceptical to attacks and it would not be an easy task for the amount
of benefit you would be getting. I would just upgrade your internet
connection. ;-)
2b.) I am pretty sure there is not a way to replicate between mysql and
mssql and I am not sure you would want to anyway it could introduce problems
to your ShelbyDabase, which, would not be fun to deal with.
3.) Our product connects directly to the shelby database. I recommend you
have a setup like this:
a.) Your public website is an offsite server, unless you
can afford a good internet connection for your main server
b.) Link your Groups section to a Shelby Center webserver
that resides locally at your church in your DMZ (no firewall)
c.) Shelby Center connects to your database server which
IS BEHIND A FIREWALL. ;-)
I am guessing these answers were probably not what you wanted to hear, but I
hope this helps and please let me know if you have any more questions.
In Him,
Jeff Berg
On 8/11/06, Bonafide_Paterfamilias <ethomas_w...@yahoo.com> wrote:
> I'm considering how I might integrate Shelby Center with an external
> web site. I'm a bit concerned about the latency and reliability of
> having Shelby Center directly connected our primary db (intranet via.
> DSL/cablemodem).
> I was hoping you could give me a few insights into how you recommend
> configuring a such a network. I understand and have had success with
> all of the unixodbc, freetds and general connectivity issues. But I'm
> still thinking through some of the following questions:
> 1. Should I create a new user account on the SQL Server ShelbyDB for
> connections from Shelby Center? If so, can I define edit permissions
> on specific tables?
> 2. Should I consider replicating my ShelbyDB to an external SQL
> Server? Can this be automated and is there anyone who provides a
> low-cost, lite SQL Server hosting?
> - Alternatively is it possible to replicate the ShelbyDB to a mySQL
> server and keep the two DB's in sync?
> 3. How reliant is Shelby Center on a stable, low-latency connection to
> the ShelbyDB? Do you utilize ShelbyDB directly or keep a local
> shadowed copy of the data? (from the code, it looks like you go
> directly to ShelbyDB).
> Any direction would be helpful.
> Regards,
> Eric
Jeff Berg
Owner/Developer
Ministry Centered Technologies
