dbForge Data Generator for SQL Server
Features Overview

dbForge Data Generator is a fast and visual tool to create random test data of different volumes. The tool supplies a lot of generators with customizable configuration options to populate SQL tables with meaningful data depending on the column names, data types, check constraints and foreign keys assigned to columns, etc. Here is an overview of the main features of dbForge Data Generator.

Basic generators

With the collection of 15+ basic random data generators, you can populate table columns 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
Basic Generators

Meaningful test data generators

dbForge Data Generator includes 200+ meaningful generators to populate tables with volumes of demo data. In particular, the tool can help you generate the following:

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

User-defined generators

Instead of customizing existing generators over and over again, you can create, save, and share your own generators that will match your needs.

In dbForge Data Generator, generators can be created either from scratch or modified from an existing template from the wide collection of pre-defined generators supplied by the tool. After you configured generator settings, you can save them as an .xml file for later use.

User-defined generators

Full support for all column data types

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

  • XML
Supported Data Types

Multiple generators with bespoke data

Data Generator comes with individual generators for each supported data type that allow you to customize:

  • Number of NULL rows
  • Number of empty rows
  • Data uniqueness
  • Value ranges
  • Value distribution mode
Multiple  generators with data customization

Support for SQL data integrity

dbForge Data Generator supports foreign keys to maintain consistent data across multiple tables. The tool automatically assigns the Foreign Key generator to the columns with foreign key constraints.

The Foreign Key (auto assigned) generator generates foreign key values for a child table column based on the values from a parent table column. If needed, you can modify basic and custom settings of the generator.

Learn more about SQL data integrity
SQL data integrity support

Support for domain integrity

dbForge Data Generator supports check constraints that ensure data consistency and accuracy across single or multiple columns of a table. The tool also allows disabling check constraints to prevent database logic break.

The Check Constraint (auto assigned) Generator automatically assigns check constraints to columns. It also uses the check constraint expression to limit the value range of data generated for the column.

Learn more about domain integrity
Domain integrity support

Multiple ways to populate data

After you configured generation options for your project, you can select the way to manage a data generation script in the Data Population Wizard:

  • Open the data population script in the internal editor of dbForge Data Generator so that you can modify the script and then execute it
  • Save the script to a file on your local computer
  • Execute a script against the database without reviewing it
Multiple ways to populate data

Command-line interface

With the command-line functionality, you can automate data generation tasks: In the Command Prompt, specify the generatedata operation and execute the command.

In addition to that, you can schedule repetitive data generation tasks at the specified time using the Task Scheduler tool. To schedule data generation, first, you need to create a .bat file in dbForge Data Generator and then create a data generation task with the help of, for example, Windows Task Scheduler.

Command-Line Interface

Automate database development with the DevOps approach

Data Generator, taking one of the key roles in the DevOps Continuous Integration process, ensures ongoing and faster delivery of high-quality software. The tool enables you to generate random data of various volumes to quickly test new and improved functionalities without requiring actual data located on client-side servers.

After you configured a data generation project, you can add it to Source Control to automate the population of the database with test data from the command line.

Automate database development with the DevOps approach

SSMS integration

dbForge Data Generator for SQL Server can easily be integrated into Microsoft SQL Server Management Studio that enables you to perform data generation tasks in a familiar interface.

To start working with Data Generator, in SSMS Object Explorer, right-click the database and select Data Generation > New Data Generation. The Data Generator tool opens where you will be able to set up a new data generation project.

SSMS integration

dbForge Data Generator for SQL Server

Fill databases with real-world data