Ask the Expert

Tool to synchronize two SQL Server databases

How can I synchronize two SQL Server databases so that changes to one database, i.e., Insert/Update, will synchronize with the other database, and vice versa?

    Requires Free Membership to View

You will want to use the merge replication tool to achieve this goal. Merge replication is designed to move data between multiple systems, where the data can be updated on any of the systems.

This was first published in March 2008

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: