synchronization between MSDE and SQL Server

  • 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

  • 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

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

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply