Redgate Hub

Product: SQL Toolbelt

The industry-standard tools for SQL Server development and deployment

Generating Realistic Test Data (16)

All databases

All levels

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 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 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

SQL Data Generator logo

How to build-and-fill multiple development databases using PowerShell and SQL Data Generator

This article offers a build-and-fill method for development databases, where each developer will subsequently want to alter the data or metadata in his or her copy of the database. Read more

SQL Data Generator logo

How to Automatically Fill your SQL Server Test Databases with Dummy Data

A PowerShell script to automatically populate a SQL Server database with dummy data, for database development and testing work. Read more

SQL Data Generator logo

How to generate realistic text data using SQL Data Generator

To get the best results, you need to provide SQL Data Generator with some hints on how the data ought to look. Phil Factor nudges it towards realistic text data. Read more

SQL Data Generator logo

Generating realistic dates using SQL Data Generator and Python

How to generate more realistic dates, in your SQL Server test data. 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

Product: SQL Toolbelt

The Joy of Realistic Generated Fake Database Data

Build and fill a database using JSON and SQL Change Automation

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

How to build-and-fill multiple development databases using PowerShell and SQL Data Generator

How to Automatically Fill your SQL Server Test Databases with Dummy Data

How to generate realistic text data using SQL Data Generator

Generating realistic dates using SQL Data Generator and Python

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

Product: SQL Toolbelt

Cookies on red-gate.com