Redgate Hub

SQL Data Generator (18)

All topics

All databases

All levels

Flyway logo

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 Data Generator logo

Getting your SQL Server Development Data in Three Easy Steps

Phil Factor takes a staged approach to generating development data, creating one project that simply copies data from an existing database, another that copies most data but generates any personal or sensitive data, and a third that starts from 'anonymized' data and then generates other columns entirely and increase the… Read more

SQL Data Generator logo

The Joy of Realistic Generated Fake Database Data

Have you ever had to demonstrate a database-driven application, and longed to have the real data to do so? To do what, precisely? Well, so you can then scroll through the customers who have used the system, demonstrate the accounting and audit, browse through the products, maybe even demo the… Read more

SQL Compare logo

Creating a Simple Development Harness with SQL Compare and SQL Data Generator

There is no single, correct approach to developing and testing your SQL batches and routines. It depends on the requirement. For simple tasks, like modifying and testing a view or stored procedure, SQL Compare and SQL Data Generator, combined, provide a useful, lightweight development harness. Read more

SQL Data Generator logo

How to Complain Bitterly using SQL Data Generator

How to use reverse regex expressions in SQL Data Generator to fill a text column in SQL Server with fake, but very realistic complaints. Read more

SQL Prompt logo

Using a Variable-length Datatype Without Explicit Length: The Whys and Wherefores (BP007/8)

If you declare a variable-length string , or coerce a string, without specifying its length, you can fall foul of ‘silent’ string truncation. Some developers resort to using the (MAX) specification, which is a mistake too. Phil Factor explains the dangers and then offers a workaround for the problem, when… 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 Data Generator logo

Pseudonymizing your data with SQL Data Generator

Starting from a database view, as the basis for a typical sales reports, Phil factor shows how to generate a data-masked version of this report, which the Tax Men can safely pore over. Read more

SQL Data Generator logo

Realistic, simulated data for testing, development and prototypes

Generating realistic test data is a challenging task, made even more complex if you need to generate that data in different formats, for the different database technologies in use within your organization. Dave Poole proposes a solution that uses SQL Data Generator as a ‘data generation and translation’ tool. Read more

SQL Data Generator logo

Generating test data in JSON files using SQL Data Generator

Phil Factor shows how to use SQL Data Generator to produce as much pseudonymized data as you are likely to need for your testing, and then convert it to JSON so that you can also use it to test your MongoDB and Azure Cosmos databases, or to test out a… 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

Redgate Hub

Adding Test Data to Databases During Flyway Migrations

Getting your SQL Server Development Data in Three Easy Steps

The Joy of Realistic Generated Fake Database Data

Creating a Simple Development Harness with SQL Compare and SQL Data Generator

How to Complain Bitterly using SQL Data Generator

Using a Variable-length Datatype Without Explicit Length: The Whys and Wherefores (BP007/8)

Pseudonymizing a Database with Realistic Data for Development Work

Pseudonymizing your data with SQL Data Generator

Realistic, simulated data for testing, development and prototypes

Generating test data in JSON files using SQL Data Generator

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

Cookies on red-gate.com