Previous Next

SQL Server Data Generator

This page provides additional information about the SQL Server Data Generator feature provided by dbForge Studio for SQL Server.

Populate your databases with test data in a snap!

When it comes to creating, modifying or testing database-driven components or applications, it is crucial to analyze their efficiency using a variety of input data and operating conditions. Such analysis helps to eliminate development gaps and ensure reliability and quality of a given approach to data processing. Since a database without data is not appropriate for ensuring that your application will work as designed, DBAs, developers, or testers face with the necessity of generating SQL test data.

Data Generator is a powerful visual component, that considerably saves your time and effort spent on test data generation by populating SQL Server tables with thousands of customizable rows of test data.

Full support of all column data types

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


Multiple generators with data customization

Individual generators for each supported data type, that allow to customize:

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

SQL data integrity support

The tool supports foreign keys for generation of consistent data across multiple tables. It also allows disabling triggers and constraints to avoid interference with database logic.

Multiple ways to populate data

The generated data population script that can immediately be executed against a SQL Server database, saved for future use or edited in the internal editor.

Basic generators

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
  • Python

Meaningful generators

180+ generators allow populating 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!

User-defined generators

Create, save, and use your own generators that would better meet your needs, instead of customizing existing generators over and over again.

Command-line interface

With the command-line functionality, you can save time by scheduling routine data generation tasks.