Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2005
    Posts
    31

    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 ?

    Thanks
    Last edited by reo_r1; 09-21-05 at 18:35.

  2. #2
    Join Date
    Jan 2003
    Location
    Nottinghamshire, UK
    Posts
    364
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •