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