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.

[Link][1] [1]: http://www.microsoft.com/technet/prodtechnol/sql/bestpractice/gems-top-10.mspx

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.

Link

From this page, 10 hidden gems:

• TableDiff.exe
• Triggers for Logon Events (New in Service Pack 2)
• Boosting performance with persisted-computed-columns (pcc).
• DEFAULT_SCHEMA setting in sys.database_principles
• Forced Parameterization
• Vardecimal Storage Format
• Indexing made easier with SQL Server 2005
• Figuring out the most popular queries in seconds
• Scalable Shared Databases
• Soft-NUMA

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.

[Link][1] [1]: http://www.microsoft.com/technet/prodtechnol/sql/bestpractice/gems-top-10.mspx