EMS Data Generator for SQL Server is an impressive tool for generating test data to SQL Server database tables with the possibility to save and edit scripts.

The utility can help you to simulate the database production environment and allows you to populate several SQL Server database tables with test data simultaneously, define tables and fields for generating data, set value ranges, generate SQL Server char fields by mask, define lists of values manually or select them from SQL queries, set generation parameters for each field type and has many other features to generate SQL Server test data in a simple and direct way.

Data Generator for SQL Server also provides a console application, which allows you to generate SQL Server test data in one-touch by using generation templates.

Key Features

  • Unicode support
  • User-friendly wizard interface
  • Ability to save and edit generated data in the SQL script without executing queries on the server
  • Support of all SQL Server data types including UNIQUEIDENTIFIER, BIT, SQL_VARIANT and TIMESTAMP types
  • Different generation types for each field including list and random generation, generation into two and more fields simultaneously
  • Ability to use SQL query results as a list of values for data generation
  • Ability to preview the generated data
  • Automatic control over referential integrity for linked tables
  • Ability to disable triggers of the generated tables during the generation process
  • Wide variety of generation parameters for each field type
  • Ability to set NULL values for certain percent of cases
  • Ability to save all generation parameters set on current wizard session into a configuration file
  • Command-line utility to generate data using the template file

In-purchase Benefits

  • FREE One Year of Maintenance already included!
  • FREE software updates and upgrades during Maintenance period!
  • FREE and unlimited Technical Support during Maintenance period!
  • Reasonable pricing for Maintenance renewal – from 35% per Year!
  • Volume discounts when buying two or more copies of one product
  • Cross-selling discounts on related products
  • 30-day money-back guarantee

Product screenshots

Specifying generation parameters
Specifying generation parameters
Setting generation options
Setting generation options
Integer field parameters

Integer field parameters
Float field parameters
Float field parameters
Date field parameters
Date field parameters
String field parameters
String field parameters

Data Generator for SQL Server

Get started with Data Generator for SQL Server

Download a fully-functional 30-day free trial, and start saving time with your database management today.

Download free trial

Got questions?

If you'd like any help, or have a question about our tools or purchasing options, just get in touch.

Related Products