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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Maintain Synchronization of Data

Author  Topic 

sree
Starting Member

2 Posts

Posted - 2006-12-20 : 10:23:18
we are planning to develop an Desktop Application with 3 systems at clientside and one system acts as a central SERVER.

How we replicate the same data in all the servers.
The Thre client Systems are located in different Geographical Area.
Dailly we need to update the data to Central SErver and next day the same data is available to all other systems.
Next day any new updates occured again the data is updated into Central server and same data is maintained in all local systems.
(This we are planning to implement in SQL SERVER 2000 and Vb.Net)
Any one can help how to proceed this Process.

KenW
Constraint Violating Yak Guru

391 Posts

Posted - 2006-12-20 : 15:06:29
sree,

See SQL Server Books Online, topic "Replication".

Ken
Go to Top of Page
   

- Advertisement -