TableDiff.exe – Compare two tables and generate insert/update/delete’s

Update (Jan 25, 2017): This is an old post. The new method of doing data compares is by using SQL Server Data Tools (SSDT). The procedure is outlined here. TableDiff is still a great command-line, no-frills option. If you interested in only finding out what rows were INSERTED/UPDATED/DELETED and have no need to generate any …

Hello Blogosphere

It is not very often you attend a session in a technical event and come out and say "wow, that makes a lot of sense". I need to do "that" starting today. I had the chance to attend not one but two such sessions - one at NYC SQL Saturday in a session by Steve Jones on …