Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
JohnJohn73
Yak Posting Veteran
57 Posts |
 Posted - 2009-06-24 : 13:23:41
|
| Hello All!Well, I'm getting ready to embark on my first real "distributed system," and I need some direction.I want to design a system that clients can access either from the Internet or from an intranet.For example, if the client cannot access the Internet for whatever reason (technical difficulties, didn't pay their bill, etc.), they can use a backup of the same database for local access.To do this, would I backup the database on the Internet server and download it to the client desktop.For example, JohnJohn logs on to the Internet system. When he prepares to close his session, a backup of the Internet database is created and then downloaded to his client computer (or possibly a LAN). That way, if he needs to use the program again and the Internet fails, he could use the local SqlServer with the latest info.Does this make sense?OK, here's my second question:If I sign up for a ISP and they provide SQL Server and ASP.NET, how much support do they give you in setting up the SQL Server? For example, do you download SQL Server Management Studio and code your DB from your development machine, or do you do all the coding on your development machine, then upload it to the server?Well, sorry for all my newb questions.Thanks in advance for any suggestions. |
|
|
JohnJohn73
Yak Posting Veteran
57 Posts |
Posted - 2009-06-25 : 09:28:15
|
| nobody? |
 |
|
|
ahmad.osama
Posting Yak Master
183 Posts |
Posted - 2009-06-25 : 09:46:27
|
quote:
Originally posted by JohnJohn73
Hello All!Well, I'm getting ready to embark on my first real "distributed system," and I need some direction.I want to design a system that clients can access either from the Internet or from an intranet.For example, if the client cannot access the Internet for whatever reason (technical difficulties, didn't pay their bill, etc.), they can use a backup of the same database for local access.To do this, would I backup the database on the Internet server and download it to the client desktop.For example, JohnJohn logs on to the Internet system. When he prepares to close his session, a backup of the Internet database is created and then downloaded to his client computer (or possibly a LAN). That way, if he needs to use the program again and the Internet fails, he could use the local SqlServer with the latest info.Does this make sense?OK, here's my second question:
Well..this means that each n every client should have sql server installed on their machine also in case of internet failure you should be able to redirect the clients to there local database automatically.Now suppose we do have a way of redirecting the application to the local database, what about the data modified at local database???u then need a mechanism to update the production database from that of local database.give this a thought ..... |
|
|
|
|
|
|
|
|
Are these things possible