Synchronize Database

[rupali]

Hello All,

I have 2 database. One is on live server
and the other on local desktop.

User can make changes in database offline on local desktop.
But later he wants to move his changes to live server and also get the updates done on live server by other users.
How can this be accomplished?
What algorithm can be applied?

[ariful alam]

You can use Replication. It is a set of technologies for copying and distributing data and database objects from one database to another and then synchronizing between databases to maintain consistency.

[rupali]

Hello ariful,

Please can you explain a bit in detail.

[ariful alam]

You can check the following links:

How to: Create a Publication (Replication Transact-SQL Programming)

Replication Stored Procedures (Transact-SQL)