Product Info
EMS Data Generator for DB2 is a powerful utility for generating test data to several DB2 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.
What's new in current version
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.
Requirements
Pentium 300; 32 MB RAM; Connection to local or remote Server; IBM DB2 client software installed
Please contact EMS Data Generator for DB2 publisher, EMS Database Management Solutions, Inc if you have questions or issues regarding this product.