Robert Sheldon demonstrates how to start automating data comparisons between two databases, from the Windows command line or PowerShell. With a single command, you can easily compare and sync data such as test data sets, or static data used for reference or lookup purposes.
2021-02-24
SQL Compare and SQL Data Compare can be used together, from the command line, to provide a complete build process, or to script out changes to both the database and its development data. For doing this routinely, I find it easiest to script the operation using PowerShell.
2021-01-15
Phil Factor dissects and disentangles the various SQL Compare options.
2020-07-28
Let's say your QA team maintain two similar test databases. They run tests to verify that different versions of the same application still produce the same, correct results. Therefore, any differences in the test data, between the two databases, needs to be corrected before the tests start. This is the sort of task for which SQL Data Compare is ideally suited, and Bob Sheldon explains how it all works.
2020-07-14
Script to facilitate the comparison of data between two SQL Server tables
2019-09-23 (first published: 2019-09-07)
3,922 reads
By Steve Jones
I had a customer ask about analyzing their Test Data Manager (TDM) usage to...
By Steve Jones
I had an idea for an animated view of a sales tool, and started...
Next Monday, February 9, 2026, my one-day live online training SQL Server Query Tuning...
I need to delete rows from both the temporal main and history tables. The...
Comments posted to this topic are about the item When SQL Server Central Went...
Comments posted to this topic are about the item The String Distance I
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('tim', 'tom')
Assume preview features are enabled. See possible answers