Redgate Hub

Topic: Database Testing

SQL Data Generator (18)

All databases

All levels

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

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

Basic data masking for development work using SQL Clone and SQL Data Generator

Richard Macaskill describes a lightweight copy-and-generate approach for making a sanitized database build available to development teams, using SQL Clone, SQL Change Automation and SQL Data Generator. 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

Topic: Database Testing

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

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

Basic data masking for development work using SQL Clone and 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

Topic: Database Testing

Cookies on red-gate.com