Sunday, November 1, 2015

Compare two SQL Server Databases


--     Table Difference tool allows you to discover and reconcile differences between a source and destination table or a view. Tablediff Utility can report differences on schema and data. The most popular feature of tablediff is the fact that it can generate a script that you can run on the destination that will reconcile differences between the tables. TableDiff.exe takes 2 sets of input;
--     Connectivity - Provide source and destination objects and connectivity information. • Table Difference tool allows you to discover and reconcile differences between a source and destination table or a view. Tablediff Utility can report differences on schema and data. The most popular feature of tablediff is the fact that it can generate a script that you can run on the destination that will reconcile differences between the tables. dbcompare.exe takes 2 sets of input;
--     Connectivity - Provide source and destination objects and connectivity information. • Table Difference tool allows you to discover and reconcile differences between a source and destination table or a view. Tablediff Utility can report differences on schema and data. The most popular feature of tablediff is the fact that it can generate a script that you can run on the destination that will reconcile differences between the tables. dbcompare.exe takes 2 sets of input;
--Connectivity - Provide source and destination objects and connectivity information.

Db compare exe Download