tablediff Utility

tablediff Utility

http://msdn.microsoft.com/en-us/library/ms162843(SQL.105).aspx

SQL Server 2005: TableDiff.exe GUI

http://weblogs.sqlteam.com/mladenp/archive/2007/08/10/60279.aspx

ex:

tablediff.exe -sourceserver king\uat -sourcedatabase courses -sourcetable pweb_parameters -destinationserver nelson\dev -destinationdatabase courses -destinationtable pweb_parameters -et diff.dbo.diff -f c:\update.sql