Redgate Hub

All products

Database Testing (23)

All databases

How to (23)

SQL Test logo

Testing SQL Server Databases Using SQL Test

During database development, as well as writing SQL, you must also write the tests that prove your SQL code meets all the requirements. The article will help you get started with database testing for your SQL Server databases, by creating and running unit tests against them, as well as static… Read more

SQL Data Compare logo

Comparing and Syncing Data using SQL Data Compare Command Line

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. Read more

SQL Data Compare logo

Testing SQL Server Stored Procedures and Functions with SQL Data Compare

Phil Factor demonstrates a cunning way to test stored procedures or functions, such as after refactoring, by storing the 'before' and 'after' results in views and then using SQL Data Compare to spot any discrepancies. Read more

SQL Clone logo

SQL Clone for Unit Testing Databases

Phil Factor demonstrates how to use SQL Clone to create 'disposable' SQL Server databases, for development and testing work. You can spin up a clone, use it to unit test your code, messing up the clone in the process, then reset the clone in seconds, ready for the next test. Read more

SQL Clone logo

Safely Deleting Clones and Images during Database Development and Testing

Whenever you’re ready to refresh a test cell with the latest database version, you need a safe way to drop the current set of clones, and the parent image, without losing any unsaved work. Phil Factor provides a PowerShell script that automates this process so it runs in the time… Read more

SQL Clone logo

Deploying and Reverting Clones for Database Development and Testing

Demonstrating how to use PowerShell automation to create a suite of clones, for testing or development work, with the ability to revert a clone to its original state, instantly, ready for the next set of tests to begin. Read more

SQL Clone logo

How to create and refresh development and test databases automatically using SQL Clone and SQL Toolbelt

A PowerShell automation script to build a SQL Server database from source control, seed it with dummy data, document it, and then deploy copies to any number of test and development servers. Read more

SQL Change Automation logo

Build and fill a database using JSON and SQL Change Automation

Phil Factor demonstrates how to export data from a database, as JSON files, validate it using JSON Schema, then build a fresh development copy of the database using SQL Change Automation, and import all the test data from the JSON files. Read more

SQL Data Generator logo

Pseudonymizing a Database with Realistic Data for Development Work

How to use SQL Data Generator, and PowerShell to obfuscate personal data (names), while retaining the same distribution of data, so that the test database behaves like the original. Read more

SQL Change Automation logo

Deploying Multiple Databases from Source Control using SQL Change Automation

How to automatically build multiple test databases, from source control, and then fill them with standard test data sets, using SQL Change Automation, BCP and some PowerShell magic. Read more

Security and compliance

Database monitoring and observability

Database change management

Productivity and workflow automation

AI data readiness

Database modernization

Efficiency and cost optimization

Cloud migration and workload optimization

Redgate Flyway

Redgate Monitor

SQL Toolbelt Essentials

Redgate Assistant

Redgate Hub

Testing SQL Server Databases Using SQL Test

Comparing and Syncing Data using SQL Data Compare Command Line

Testing SQL Server Stored Procedures and Functions with SQL Data Compare

SQL Clone for Unit Testing Databases

Safely Deleting Clones and Images during Database Development and Testing

Deploying and Reverting Clones for Database Development and Testing

How to create and refresh development and test databases automatically using SQL Clone and SQL Toolbelt

Build and fill a database using JSON and SQL Change Automation

Pseudonymizing a Database with Realistic Data for Development Work

Deploying Multiple Databases from Source Control using SQL Change Automation

2026 State of the Database Landscape

Introduction to PostgreSQL for the data professional

Security and compliance

Database monitoring and observability

Database change management

Productivity and workflow automation

AI data readiness

Database modernization

Efficiency and cost optimization

Cloud migration and workload optimization

Redgate Flyway

Redgate Monitor

SQL Toolbelt Essentials

Redgate Assistant

Cookies on red-gate.com