dbForge Data Generator for SQL Server is a powerful GUI tool for a fast generation of meaningful test data for databases. dbForge dummy data generation tool includes 200+ predefined data generators with sensible configuration options, that allow to emulate column-intelligent random data. The tool also allows generating demo data for databases already filled with data and create your own custom test data generators. dbForge Data Generator for SQL Server can save your time and effort spent on demo data generation by populating SQL Server tables with millions of rows of sample data that looks just like real data.

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 data customization

Data Generator comes with 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.