synchronization between MSDE and SQL Server

• Rahuul

  Mr or Mrs. 500

  Points: 581

  More actions

  July 1, 2004 at 12:49 am

  #83077

  Hi,

  How does SQL Server synchronize data? I need to synchronize data from MSDE to one centralized SQL Server. The scenario is each user will be working in his own MSDE and on a periodical basis they do the synchronization with the Centralized SQL Server. They will update their data and in the same time they will fetch new data which has come in from other users to the Centralized SQL Server.

  Please suggest me as how to go about it. Any synchronization script would be great.

  Thanks,

  Rahuul

• WSquared

  SSCrazy

  Points: 2393

  More actions

  July 1, 2004 at 7:06 am

  #512875

  Hi Rahuul,

  Have a look at merge replication, you need to create a publication on the central database and then create subscriptions to that db in MSDE

• Rahuul

  Mr or Mrs. 500

  Points: 581

  More actions

  July 1, 2004 at 10:15 pm

  #513066

  I m looking for some synchronization script. If you have please give it me.