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 and provides greater flexibility and manual control over the creation of the foreign key data. With the column-intelligent data generation, the generated data in a 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 consistent data across multiple tables with data integrity support
  • Preserve inter-column data dependencies with domain integrity support
  • Create, set up, and share custom-made generators across your team
  • Automate and schedule data generation routines with command line
  • Integrate test data generation right into SQL Server Management Studio
Features

Full support for all column data types

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

  • GEORGAPHY
  • 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. Disabling triggers and constraints to avoid interference with database logic.

SQL data integrity support

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 database logic is included as well.

dbForge Data Generator for SQL Server - Domain integrity support

Multiple ways to populate data

Use test data population script for population of a SQL database with test data in a way you need:

  • Immediate execution against a SQL Server database
  • Saving for the future use
  • Editing in the internal editor
Multiple ways to populate data

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 to populate tables with realistic test data. In particular, tool can fill your tables with:

  • IDs
  • Post codes
  • Phone numbers
  • Countries
  • Credit card numbers
  • E-mails
  • Social Security Numbers
  • First & Last Names
  • Product Categories
    • ...and much more!
Meaningful Generators

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 the random data generation project settings for the future use
  • Use the command-line interface or PorwerShell 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 on a schedule with Windows Scheduler.
Command-Line Interface

Great Choice of Sample
Data Generators

Basic 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.

Business Data Generator

Business

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

Health Data Generator

Health

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

IT Data Generator

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, and others.

Location Data Generator

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 Data Generator

Payment

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

Person Data Generator

Person

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

Product Data Generator

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
Your testimonials More testimonials

Data Generator is a part of SQL Tools

SQL Tools includes a pack of essential SSMS add-ins and tools

Find out more

Get Started with Data Generator for SQL Server at no cost

Download a FREE 30-day trial of the tool, and start saving time and efforts with your SQL test data generation right away.

Download free

Buy multi-user licenses with substantial discount

We provide flexible purchase options, including bulk discounts, to meet the need and budget of each and every customer.

Purchase now

Need a hand?

If you need any help or have questions about Devart tools or purchasing options, do not hesitate to get in touch with us.

Takes part in DevOps Automation

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

Unveil benefits
Dev Ops
Your subscription could not be saved. Please try again.
Your subscription has been successful.

We use cookies to provide you with a better experience on the Devart website. You can read more about our use of cookies in our Cookies Policy.
Click OK to continue browsing the Devart site. Be aware you can disable cookies at any time.