Online Documentation for SQL Management Studio for SQL Server

Running Data Generator

EMS Data Generator for SQL Server is a powerful utility for generating test data to several SQL Server database tables at once. The application provides a lot of features to generate test data in a simple and direct way.


Data Generator for SQL Server provides you with an easy-to-use Wizard which guides you through all the steps of data generation process: you can define tables and fields for generating data, set value ranges, generate char fields by mask, load values for BLOB fields from files, get lists of values from SQL queries and more.

Additionally to the GUI version which is implemented in the form of a Wizard application, Data Generator for SQL Server includes the console version which is intended for running from Windows command line with a template file name used as the execution parameter.


To run Data Generator for SQL Server, click its icon or caption on the Desktop Panel and follow the steps of the Wizard. If necessary, you can click the Arrow-down button to open the menu allowing you to specify a template, and run the wizard/console with the template.


To manage configuration files (templates), use the corresponding Manage templates link. In this case you will be redirected to the Template Management section of SQL Studio.


Data Manipulation - Running Data Generator