SQL 2005 tablediff command line utility.

This utility allows you to compare the contents of one table against another to find any differences and get T-SQL script to sync them up, i.e. does what WinMerge does for your files. Tablediff article in books online provides all the details. In order to run this command you need to have primary keys setup on both tables, which makes sense.

No comments: