How to: Compare and Synchronize the Data of Two Databases

Question

Visual Studio 2012   How to: Compare and Synchronize the Data of Two Databases

---

高海东

Answer 1

http://msdn.microsoft.com/query/dev10.query?appId=Dev10IDEF1&l=ZH-CN&k=k(VS.TEAMSYSTEM.DATACOMPARE.CONNECTION.DATASOURCES.F1)&rd=true

---

高海东

Answer 2

you can use

• log shipping
• mirroring
• replication

for data syuncronization between 2 databases. you can choose any one of them which suit your requirement

---

Ramesh Babu Vavilla MCTS,MSBI

Answer 3

You can use Data compare and sync tools. This blog post contains commercial and free tools name and links.

http://sqlserverrider.wordpress.com/2013/07/13/sql-server-data-comparison-and-synchronization-tools-voting/

---

Thanks Ayyappan Thangaraj, http://SQLServerRider.wordpress.com