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,778 reads
Image from Afdhaluddin on ShutterstockCLI which is generally referred to as Command Line Interface...
By Steve Jones
I can’t believe I’ve been at Redgate long enough to get a third sabbatical....
By Steve Jones
Don’t let someone else’s urgency becomes your emergency. In fact, don’t be governed by...
Hi, I’ve provisioned an Azure Database Watcher to monitor our 4 Azure SQL Managed...
Comments posted to this topic are about the item Can You Ask for a...
Comments posted to this topic are about the item Stored Procedure Generation Script
What is returned by this code in SQL Server 2022?
SELECT value FROM GENERATE_SERIES(4, 1);See possible answers