EMS Data Generator 2005 for SQL Server Review

EMS Data Generator for SQL Server is a powerful utility for generating test data to several Microsoft SQL database tables at once. The wizard application allows you to 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 many other features to generate test data in a simple and direct way. It also provides you console application, which allows you to generate data in one-touch by using generation templates.

Features:

- User-friendly wizard interface;
- All MS SQL data types support including UNIQUEIDENTIFIER, BIT, SQL_VARIANT and TIMESTAMP types;
- Different generation types for each field including list, random, incremental data generation and more;
- Ability to use SQL query results as list of values for data generation;
- Automatic control over referential integrity for linked tables data generation;
- Wide variety of generation parameters for each field type;
- Ability to set NULL values for certain percent of cases;
- Possibility of saving all the generation parameters, set on current wizard session;
- Command-line utility to generate data using the template file.

- 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.

Pentium 166; 32 MB RAM; Possibility to connect to some local or remote Microsoft SQL Server

Please contact EMS Data Generator 2005 for SQL Server publisher, EMS Database Management Solutions, Inc if you have questions or issues regarding this product.

Awful

Poor

Average

Good

Excelent