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 |
|
Aiby
Yak Posting Veteran
71 Posts |
 Posted - 2003-12-14 : 03:02:45
|
| How can I synchronize a SQL Data base in a local server to the Web Server database. ( keeping a Mirror database). Purpose: I have implement client server application in to three remote sales centers and have to provide remote administration for the management people and marketing people using a web application. The total stock position and individual centers detail out standing payments and updates should be monitored through either web application or through local sales centers. Issue of Synchronization and Distributed Client server applicationIf some one have any such development experiance,... i would like to get their expert advice...Thank you..Regards..Aiby Mohan DasSystem AnalystOviaym info solutions & Technologies P.Ltd.Kerala, IndiaEmail: Aiby@hotmail.com |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-12-15 : 12:49:39
|
| So you have two database servers? Why not just have the web server connect to the SQL Server? Anyway, if you've got two database servers and need to keep them in synch, you will want to implement replication. Replication is not an easy topic to cover in a thread. I would suggest reading all about it in SQL Server Books Online. Vyas has a bunch of information on his site as well: http://vyaskn.tripod.comTara |
 |
|
|
Aiby
Yak Posting Veteran
71 Posts |
Posted - 2003-12-20 : 11:24:10
|
| Local Server Database and Web servers are required cus.. the process is not completely online... I would like to synchorize it by a daily routine... ok i will go through that reffered site and report to you.. very soon.. thank you Tara.. |
|
|
|
|
|
|
How i cud Synchronize my local server database to