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

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

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.

Full support for all column data types

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

GEORGAPHY
GEOMETRY
HIERARCHYID
DATETIME2
DATETIMEOFFSET
XML

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

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

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

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.

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.

dbForge Data Generator for SQL Server Features Overview