EMS Data Generator for DB2 is an impressive 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 console application, which allows you to generate data in one-touch by using generation templates.


Key Features
User-friendly wizard interface
Generating data to several tables from different schemas of database
Support for generic DB2 data 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
Saving all generation parameters set on current wizard session
Command-line utility to generate data using the template file