download25.com

Your free TOP 25 download source!

EMS Data Generator 2005 for SQL Server 2.3

Utility for generating test data to several Microsoft SQL database tables.
Publisher: EMS Database Management Solutions, Inc
Category: Development Tools
Version: 2.3
License: shareware
Cost: buy 95$
Size: msdatagen.zip 2.86 MB
Updated: 05 Sep 2008
Screenshot: view screenshot
Bookmark: Click here
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.

Changelog:
Version: 2.3(05 Feb 2007)
- 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
Tags: Ems | Data | Generator | Sql | Server

download (msdatagen.zip - 2.86 MB)