Cool SQL 2005 Tool!

This is soooooo cool!!!!

TableDiff.exe

•

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.

•

Compare Options – Select one of the compare options

•	Compare schemas: Regular or Strict
•	Compare using Rowcounts, Hashes or Column comparisons
•	Generate difference scripts with I/U/D statements to synchronize destination to the source.

TableDiff was intended for replication but can easily apply to any scenario where you need to compare data and schema.

You can find more information about command line utilities and the Tablediff Utility in Books Online for SQL Server 2005.

How can you not get excited about this kinda stuff?!?!?!?!?!???

About JohnHowell

I am a professional software developer with over 20 years of experience. I currently specialize in Microsoft technologies such as VS, TFS, C#, VB.Net, WCF, WPF, WW, etc.

View all posts by JohnHowell →

This entry was posted in Development. Bookmark the permalink.