Redgate logo
  • Products
    • All products
    • Automate database deployments
      • Flyway Enterprise
    • Monitor performance and availability
      • SQL Monitor
    • Standardize team-based development
      • SQL Prompt
      • SQL Search
      • Flyway
      • SQL Source Control
      • Source Control for Oracle
      • SQL Compare
      • Schema Compare for Oracle
      • SQL Data Compare
      • Data Compare for Oracle
    • Protect and preserve data
      • SQL Provision
      • Data Masker
      • SQL Clone
      • SQL Backup
      • SQL Data Catalog
    • .NET
      • .NET Developer Bundle
      • .NET Reflector
      • ANTS Performance Profiler
      • ANTS Memory Profiler
      • SmartAssembly
    • All products
      • .NET Developer Bundle
      • .NET Reflector
      • ANTS Memory Profiler
      • ANTS Performance Profiler
      • Data Compare for Oracle
      • Data Masker
      • Flyway
      • Schema Compare for Oracle
      • SmartAssembly
      • Source Control for Oracle
      • SQL Backup
      • SQL Clone
      • SQL Compare
      • SQL Data Catalog
      • SQL Data Compare
      • SQL Data Generator
      • SQL Dependency Tracker
      • SQL Doc
      • SQL Index Manager
      • SQL Monitor
      • SQL Multi Script
      • SQL Prompt
      • SQL Provision
      • SQL Scripts Manager
      • SQL Search
      • SQL Source Control
      • SQL Test
  • Solutions
    • Overview
    • By Need
      • Standardize
      • Automate
      • Monitor
      • Protect
    • By Role
      • Development
      • Operations
      • IT Management
      • Enterprise leadership
    • By Industry
      • Tech
      • Finance
      • U.S. Federal
      • Australian Government
      • Healthcare
      • Manager Service Providers
    • Resources
    • Maturity assessment
  • Our Company
    • Overview
    • Careers
    • Contact us
    • Redgate blog
    • Press kit
  • Support
  • Learning & community
    • Learning & community | Redgate Hub
    • Product articles
    • University
    • Events
    • Forums
    • Community
    • Simple Talk
  • Buy now
    • See all products
    • Request a quote
    • Contact sales
    • My account
    • Shopping cart
  • Products
    • All products
    • Automate database deployments
      • Flyway Enterprise
    • Monitor performance and availability
      • SQL Monitor
    • Standardize team-based development
      • SQL Prompt
      • SQL Search
      • Flyway
      • SQL Source Control
      • Source Control for Oracle
      • SQL Compare
      • Schema Compare for Oracle
      • SQL Data Compare
      • Data Compare for Oracle
    • Protect and preserve data
      • SQL Provision
      • Data Masker
      • SQL Clone
      • SQL Backup
      • SQL Data Catalog
    • .NET
      • .NET Developer Bundle
      • .NET Reflector
      • ANTS Performance Profiler
      • ANTS Memory Profiler
      • SmartAssembly
    • All products
      • .NET Developer Bundle
      • .NET Reflector
      • ANTS Memory Profiler
      • ANTS Performance Profiler
      • Data Compare for Oracle
      • Data Masker
      • Flyway
      • Schema Compare for Oracle
      • SmartAssembly
      • Source Control for Oracle
      • SQL Backup
      • SQL Clone
      • SQL Compare
      • SQL Data Catalog
      • SQL Data Compare
      • SQL Data Generator
      • SQL Dependency Tracker
      • SQL Doc
      • SQL Index Manager
      • SQL Monitor
      • SQL Multi Script
      • SQL Prompt
      • SQL Provision
      • SQL Scripts Manager
      • SQL Search
      • SQL Source Control
      • SQL Test
  • Solutions
    • Overview
    • By Need
      • Standardize
      • Automate
      • Monitor
      • Protect
    • By Role
      • Development
      • Operations
      • IT Management
      • Enterprise leadership
    • By Industry
      • Tech
      • Finance
      • U.S. Federal
      • Australian Government
      • Healthcare
      • Manager Service Providers
    • Resources
    • Maturity assessment
  • Our Company
    • Overview
    • Careers
    • Contact us
    • Redgate blog
    • Press kit
  • Support
  • Learning & community
    • Learning & community | Redgate Hub
    • Product articles
    • University
    • Events
    • Forums
    • Community
    • Simple Talk
  • Buy now
    • See all products
    • Request a quote
    • Contact sales
    • My account
    • Shopping cart

OVERVIEW

  • Compliant Database DevOps

BY NEED

  • Standardize team-based development
  • Automate database deployments
  • Monitor performance and availability
  • Protect and preserve data

BY ROLE

  • Development
  • Operations
  • IT Management
  • Enterprise leadership

BY INDUSTRY

  • Tech
  • Finance
  • U.S. Federal
  • Australian Government
  • Healthcare
  • Managed Service Providers
PASS Data Community Summit logo

PASS Data Community Summit 2023

Get all the latest announcements direct to your inbox

Redgate Hub

  • Product articles
  • University
  • Events
  • Forums
  • Community
  • Simple Talk

Product articles
SQL Data Compare
Generating Realistic Test Data

  • Flyway
  • SQL Data Compare
  • Database Testing
  • Generating Realistic Test Data

Adding Test Data to Databases During Flyway Migrations

How to add test data to a SQL Server database, during Flyway development. We use SQL Data Generator to produce some "realistic but fake" data and then SQL Data Compare to produce an INSERT script that Flyway can use to load the data into a newly-built version of the database. Read more

  • SQL Change Automation
  • SQL Data Compare
  • Generating Realistic Test Data

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

Products

  • Flyway
  • SQL Change Automation
  • SQL Compare
  • SQL Data Compare
  • SQL Data Generator
  • SQL Toolbelt

Filter by level

Redgate Hub

  • Product Articles

    Product Articles

    Tips and how-to guides for Redgate products

  • University

    University

    Easy to follow video courses

  • Events

    Events

    Join us online, or get sponsored

  • Forums

    Forums

    Ask, discuss, and solve questions about Redgate's tools

  • Community

    Community

    Develop your skills and meet Redgate Advocates and Friends

  • Simple Talk

    Simple Talk

    In-depth articles and opinion from Redgate's technical journal

The Redgate Update Get the latest news and training with the monthly Redgate Update Sign up

Products

  • Automate
  • Monitor
  • Standardize
  • Protect & preserve

Support

  • Forums
  • Contact product support
  • Find my serial numbers
  • Download older versions

Solutions

  • Overview
  • Maturity Assessment

Our Company

  • Careers
  • Contact us
  • Redgate Blog
  • Our values

Community & Learning

  • Product Learning
  • University
  • Events & Friends
  • Simple Talk
  • Books
  • Forums

Partners

  • SQL Server Central
  • Resellers
  • Consulting partners

Privacy & compliance

  • Privacy and cookies
  • License agreement
  • Accessibility
  • Report security issue
  • Modern slavery
  • Gender pay gap report
  • CCPA - Do not sell my data

Follow us

Redgate on Twitter Redgate on LinkedIn Redgate on YouTube
  • Copyright 1999 - 2023 Red Gate Software Ltd