redgate SQL Data Generator

redgate SQL Data Generator

Generate realistic test data fast

Create large volumes of data within a couple of clicks in SQL Server Management Studio

SQL Data Generator is a fast, simple tool for generating realistic test data.

It can instantly provide generators based on table and column names, field length, data types, and other existing constraints. They can be customized to meet your requirements.

Features

Create large volumes of data within a couple of clicks in SQL Server Management Studio

Generate meaningful test data at row level

Column-intelligent data generation – generate data in one column based on the data in another

Greater flexibility and manual control for creating foreign key data

Extremely fast data generation

Over 60 built-in generators with sensible configuration options

Shareable custom generators – save regexp and SQL statement generators to share with your team

Write your own custom generators in Python, so you can create any extra data you need

Seeded random data generation allows you to generate the same collection of data every time

Foreign key support for generating consistent data across multiple tables

Inter-column dependency support

Command-line support for automated data generation

Import data from existing data sources

Automatic data conversion when the source data is a different data type

Optionally disable triggers and constraints to avoid interfering with database logic

Support for Microsoft SQL Server 2005, 2008, 2012 R2, 2014, and SQL Server on Amazon RDS

Screenshot tour

Preview and customize the data

Generate your test data

The data has been created

Cross column generators generate data based on other columns

Use Python scripts to generate your own custom data

Generate data from within SQL Server Management Studio

Part of our Database DevOps solution

Redgate’s Database DevOps solution lets you extend your DevOps practices to SQL Server databases so that you can optimize productivity, agility and performance across the full database lifecycle and become a truly high performing IT organization.

From safely making a change in development through to monitoring its impact in production, Redgate is with you every step of the way. We gives you the tools and insight you need to optimize your development processes, so you can keep your team moving, keep adding value and keep your data safe.