Redgate Hub

Product articles
University
Events
Forums
Community
Simple Talk

SQL Data Compare (2)

Generating Realistic Test Data (2)

All databases

All levels

Flyway logo

Flyway
SQL Data Compare
Test Data Management
Database Testing and Quality
SQL Server

Adding Test Data to Databases During Flyway Migrations

How to generate "realistic but fake" SQL Server test data, using SQL Data Generator, and then use SQL Data Compare to produce an INSERT script that Flyway can run to load the data into the database. The technique is useful for managing small volumes of test data or for "topping… Read more

SQL Change Automation logo

SQL Change Automation
SQL Data Compare
Generating Realistic Test Data
Database Builds and Deployments

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

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 Test Data Manager