Redgate Test Data Manager

Create an empty target database

Subsetting requires the target database to contain all the tables that will receive the subsetted data, but without data rows in those tables. There are several ways to do this, some of which are listed below.

Create a target database with Flyway

If you have access to Flyway, you can create a target database using its baseline script feature to create a copy of the source tables without any data.

Creating a target database by exporting scripts (SQL Server only)

SQL Server Management Studio can be used to create SQL scripts that will create an empty copy of the source database.

These scripts can be executed in a different SQL Server instance from the source database.

Step-by-step instructions are given in this Microsoft tutorial


Didn't find what you were looking for?