Q

Tool to synchronize two SQL Server databases

Discover a tool that synchronizes two SQL Server databases allowing changes to one SQL Server database to update on the other.

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?
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 last published in March 2008

Dig Deeper on SQL Server Replication

PRO+

Content

Find more PRO+ content and other member only offers, here.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

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

Please create a username to comment.

-ADS BY GOOGLE

SearchBusinessAnalytics

SearchDataCenter

SearchDataManagement

SearchAWS

SearchOracle

SearchContentManagement

SearchWindowsServer

Close