EMS Data Generator for DB2 is a utility that generates test data for multiple DB2 database tables. Users can define tables, set value ranges, generate character fields and blobs, and more using a wizard application.

Users can take advantage of the console application, which makes generating data with just one touch possible, thanks to the readily available generation templates. With more features to explore, this powerful utility for generating test data is an excellent software to consider.
Among the numerous features of EMS Data Generator for DB2 is the user-friendly wizard interface that simplifies the process of data generation, as well as support for all MS SQL data types, including UNIQUEIDENTIFIER, BIT, SQL_VARIANT, and TIMESTAMP types.
This software also provides different generation types for each field, implying list, random, incremental data generation, and more, which means that users are spoilt for choice when creating test data. The ability to use SQL query results as a list of values for data generation is another notable feature, as is the software's automatic control over referential integrity for linked tables data generation.
EMS Data Generator for DB2 offers a wide variety of generation parameters for each field type, including the ability to set NULL values for a certain percentage of cases. It is also possible to save all the generation parameters that users set on their current wizard session, enabling them to reuse their choices effortlessly.
Lastly, EMS Data Generator for DB2 includes a command-line utility that allows users to generate data using the template file. This versatile tool is invaluable for generating large amounts of test data in a matter of seconds. In conclusion, EMS Data Generator for DB2 packs a punch with its extensive features, easy-to-use interface, and effective results, making it a top-choice software for data testers.
Version 3.0: N/A
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.