EMS Data Generator for SQL Server generates test data for multiple Microsoft SQL database tables with the ability to set value ranges, define tables and generate char fields and blobs through a wizard application.
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.
Version 3.0:
Unicode support is implemented.
Added new options for data generation to SQL script.
Added options for generating the same data into several columns.
Added options for generating string data according to the sample text.
Data preview is implemented.
Version 2.3:
- Improved data generation for tables with Foreign keys.
- The order the tables are cleared has been corrected according to their dependencies.
- Generation data for arrays (Interbase/Firebird.
- Implemented Private Key support for SSH authentication.
- Other improvements and bugfixes.
Version 2.2: New data generation options and speed improvements...