09-21-05, 16:33 #1Registered User
- Join Date
- Aug 2005
Unanswered: Synchronization of SQL server 2000 & SQL-Express data
I have a master database containing data from many client databases located in various locations.
I have to synchronize data between the master & client databases. If data in client changes, the master needs to be updated. If the data in Master changes, the client needs to be updated.
Because of the security issue, the client location will initiate this process of Synchronization. It has to be automatic process scheduled once everyday. The Client databases are SQL-Express Databases and the Master is Sql Server 2000 database.
What is the industry standard or the best way to achieve this task ? Are their any tools that easily accomplish this? Can SQl Server Replication achieve this ?
Last edited by reo_r1; 09-21-05 at 17:35.
09-22-05, 18:29 #2Registered User
- Join Date
- Jan 2003
- Nottinghamshire, UK
I would suggest express edition clients be set up as a PULL Merge Replication Subscriber to the Master Database (Publisher)
Express version does support this
GW"Everything should be made as simple as possible, but not simpler." - Albert Einstein
"Everything should be made as complex as possible, so I look Cleverer." - Application Developer