Generate Realistic Test Data for Databases in a Wink

Implement new standards for the population of SQL tables with random data with our visual data generation tool. Data Generator includes 200+ meaningful SQL data generators with sensible configuration options. It provides great flexibility and manual control over the creation of the foreign key data. With the column-intelligent data generation, the data in one column is based on the data of another.

Create large volumes of meaningful test data with no hustle and bustle
Eliminate hours of manual data population and profit from new time slots
Keep your data consistent across multiple tables with data integrity support
Preserve inter-column data dependencies with domain integrity support
Create, set up, and share custom generators with your team
Automate and schedule data generation routines with the command line
Integrate test data generation right into SQL Server Management Studio

Data Generator Killer feature

Domain integrity aware generation

Populate databases with loads of realistic test data preserving domain-level data integrity and thus ensuring overall data accuracy, consistency, and completeness.

Features

Full support for all column data types

The tool supports a massive range of column data types, including:

GEOGRAPHY
GEOMETRY
HIERARCHYID
DATETIME2
DATETIMEOFFSET
XML

dbForge Data Generator for SQL Server - Support for all column data types

Multiple generators with bespoke data

Add a great set of individual generators for each supported data type to your SQL tool collection, and benefit from multiple customization options, including:

Number of NULL rows
Number of empty rows
Data uniqueness
Value ranges
Value distribution mode

dbForge Data Generator for SQL Server - Multiple random data generators with SQL data customization

SQL data integrity support

Support for foreign keys delivers generation of consistent random data across multiple tables. Disable triggers and constraints to avoid interference with the database logic.

Domain integrity support

Check constraints help generating consistent test data across a single column or multiple columns of a table. An option to disable check constraints to avoid interference with the database logic is included as well.

Multiple ways to populate data

Use test data population scripts for your SQL databases:

Immediate execution against a SQL Server database
Saving scripts for future use
Editing scripts in the internal editor

Basic generators

With the collection of 15+ basic random data generators, you can populate tables with various types of values. The tool includes the following generators:

Constant
Files Folder
Foreign Key
Lorem Ipsum
Regular Expression
Shuffled Text
SQL Query
Table or View
Text File
Twaddle
Weighted Lists
JSON

dbForge Data Generator for SQL Server - Basic Generators

Meaningful test data generators

Data Generator for SQL Server includes 200+ meaningful generators that allow populating tables with realistic test data:

IDs
Post codes
Phone numbers
Countries
Credit card numbers
E-mails
Social Security Numbers
First & Last Names
Product Categories

User-defined generators

Create, save, and share custom-tailored generators that perfectly meet specific data generation tasks and forget about customization of existing generators over and over again.

dbForge Data Generator for SQL Server - User-Defined SQL Data Generators

Command-line interface

Save your random data generation project settings for future use
Use the command-line interface or PowerShell for automatic routine test data generation
Save data population settings as a command-line execution file (.bat) and run it whenever you need
Schedule .bat file execution with Windows Scheduler

Great Choice of Sample
Data Generators

Basic

Populate tables with various types of values using basic demo data generators such as Python, RegExp, Lorem Ipsum, Text File, Files Folder, Weighted List, and many others.

IT

Populate database with realistic random data associated with information technology, including IPv4 and IPv6 addresses, as well as MAC addresses, file extensions, file names, file paths, etc.

Health

Create exhaustive random data related to health care: drug names, diagnoses and procedures, drug codes, etc.

Business

Emulate test data of a company's database with departments, industry sectors, IMO, SEDOL, NAICS, and ISIC Rev4.

Location

Generate country-specific demo data for real localized values, such as first names (female and male), last names, addresses, streets, cities, phones (USA, Canada, United Kingdom, Germany, Australia).

Payment

Fill payment-related tables with credit card details, currencies, VATID, IBAN, SWIFT-BIC, ABA RTN codes, and more.

Person

Create large volumes of personal sample data from names and emails to honorific prefixes, job titles, and social security numbers.

Product

Generate dummy data for product tables with such attributes as product names, descriptions, categories, shipping methods, sizes, weights, colors, and more.

Been in this business for many more years than I wish to admit to and this is one of the best products I have ever used. Once you work your way through the various options and suddenly learn that you can create your own 'pick-list' of values for a field, then the world opens up...

Michael Godfrey, Founder and CEO, MayRiver Technologies, LLC

Write a testimonial More testimonials

Data Generator as part of DevOps Automation

Use Data Generator along with dbForge DevOps Automation for SQL Server to extend your DevOps approach to SQL Server databases. The solution makes it easy to integrate SQL Server database tools into the DevOps process without compromising quality, performance, or reliability.

Explore

Get extra benefits with Devart for Enterprise

Grow your business with Devart – become our Enterprise client and get a customized package of SQL Server management software, tailored to your business needs and demands.

Bonuses for corporate clients
These may include fast and effective deployment, corporate budget optimization, and a number of special deals.

Dedicated manager
We will save your time by providing a dedicated manager to consult you and guide you through all the purchasing and licensing processes.

Learn more

How to get a discount on dbForge products

Step 1

Fill in the form

Step 2

Wait for a reply

Step 3

Get a discount

Generate Realistic Test Data for Databases in a Wink