For the best web experience, please use IE11+, Chrome, Firefox, or Safari

Test data generator

ApexSQL Generate is a tool that can populate SQL databases with test data using multiple generators for each column. It supports a full range of SQL data types and can recognize them in a loaded SQL database and provide real-world test data based on contained data types.
Test data generator

Benefits

  • Generate SQL test data for specified tables

  • Export test data to SQL, XML, CSV, JSON, Excel

  • Generate millions of rows quickly

  • Customize test data plan with detailed options

  • Support a full range of SQL data types

  • Choose from multiple generators (Random, List, etc.)

  • Retain data consistency with foreign key support

  • Emulate real-world test data

Features

Full SQL Server data type support

Generate test data across all SQL Server data types

Predefined generators

Use 150+ predefined generators for meaningful data, e.g. names, addresses, credit card numbers, social security numbers

Cross-column dependency support

Generate test data based on another column’s values with predefined conditional, string, date and numeric functions

Customization

Use a wide range of predefined options to customize data, like seed, length, minimum and maximum values, uniqueness of data, and percentage of null values. Learn more

User defined generators

Save any generator’s settings so it can be reused later with an already prepared setup. Learn more

Table mapping

Use intelligent column recognition pattern to populate table with data from external sources like other database tables and views or CSV files. Learn more

Trigger and Check constraint handling

Disable Triggers and Check constraints to avoid referential integrity errors

Relational integrity support

Include or exclude dependent objects in the generation process

Exports

Execute the generated data against a database or choose one of the exporting options

Generated data preview

Preview generated data before executing or exporting

GUI warnings

Display errors, warnings and info messages in the tree view and preview panel for incorrect generator settings, circular dependencies, constraint violations, info messages regarding DELETE triggers enforced for the selected column and more

Post generation summary

Track progress, possible errors and the number of rows successfully inserted into the database and the time span of the generation process

Modular test plans

Build inheritance into test data plans by copying existing database settings

Command Line Interface

Fully automate the test data generation process. Learn more

Visual themes

Customize the visual appearance with interface themes. Learn more

Testimonials

Clinical NetwoRx

I have worked for 18 yrs as a developer and for the past 5 yrs I have been an application manager, never have I seen a prompt response in my career. Worked with tons of products most of them not as good, but kudos to you man, you have got a great product and promising support.

Trenton D Souza Application Manager, Clinical NetwoRx

Connected System Developer

Thanks for great products!

John Saunders Microsoft MVP, Connected System Developer

ApexSQL Generate is part of the ApexSQL DevOps toolkit

ApexSQL DevOps toolkit

Get started now

Generate random test data for SQL Server.