EMS Data Generator for SQL Server

EMS Data Generator for SQL Server is an exceptional software that caters to Microsoft SQL database tables simultaneously with generated test data. Its user-friendly wizard interface allows you to define tables and fields, set value ranges, generate character fields by mask while loading values for BLOB fields from files, as well as providing a variety of other features. EMS Data Generator for SQL Server simplifies test data generation in every aspect.

This software also provides a console application to generate data in one touch by using generation templates for better automation. EMS Data Generator supports all MS SQL data types, including UNIQUEIDENTIFIER, BIT, SQL_VARIANT, and TIMESTAMP types, enabling different types of field generation methods such as random, incremental, or list depending on the field's requirements. You can even use SQL query results as a list of values for data generation, which saves time and effort.

Moreover, EMS Data Generator ensures automatic control over referential integrity for linked tables, making it easier to generate data for the whole system. It offers a wide variety of generation parameters for each field type, which helps you in setting NULL values for certain percentages of cases. By saving all generation parameters set on the current wizard session, you can efficiently manage test data generation.

In conclusion, EMS Data Generator for SQL Server offers several advanced features that increase the software's efficiency and give users ease of use, such as the command-line utility to generate data using the template file. With all these features, EMS Data Generator for SQL Server is the perfect software for creating and managing test data in Microsoft SQL databases.