Black Friday is here! Get up to 30% off on Devart products!
ends in   {{days}}
Days
{{timeFormat.hours}}
:
{{timeFormat.minutes}}
:
{{timeFormat.seconds}}

Generate Realistic Random Data for SQL 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. It provides great flexibility and manual control over the creation of the foreign key data. With the column-intelligent data generation, the data in one column is based on the data of another.

Watch the Introductory Video
  • 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 your data consistent across multiple tables with data integrity support
  • Preserve inter-column data dependencies with domain integrity support
  • Create, set up, and share custom generators with your team
  • Automate and schedule data generation routines with the command line
  • Integrate test data generation right into SQL Server Management Studio

Data Generator killer feature

Domain integrity aware generation

Populate databases with loads of realistic test data preserving domain-level data integrity and thus ensuring overall data accuracy, consistency, and completeness.

Download free trial Learn more

Why choose Data Generator

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
Data Generator for SQL Server includes 200+ meaningful generators that allow populating tables with realistic test data:
  • IDs
  • Post codes
  • Phone numbers
  • Countries
  • Credit card numbers
  • E-mails
  • Social Security Numbers
  • First & Last Names
  • Product Categories
  • Random numbers
    • ...and much more!
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.
  • Save your random data generation project settings for future use
  • Use the command-line interface or PowerShell 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 with Windows Scheduler
The tool supports a massive range of column data types, including:
  • GEOGRAPHY
  • GEOMETRY
  • HIERARCHYID
  • DATETIME2
  • DATETIMEOFFSET
  • XML
Add a great set of individual SQL dummy data 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
  • Date ranges
  • Value distribution mode
View all features

Great Choice of Sample Data Generators