EMS Data Generator 2005 for Oracle 2.3

EMS Data Generator 2005 for Oracle 2.3 offers an effective tool which helps you to generate test data to several Oracle 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.

Major Features:

1. Unicode support
2. User-friendly wizard interface
3. Ability to save and edit generated data in the SQL script without executing queries on the server
4. Support of basic Oracle data types including NUMERIC, CHARACTER, DATETIME (DATE, TIMESTAMP), INTERVALS and BINARY (RAW, LONG RAW, BLOB)
5. Ability to select different types of data insertion: through INSERT or MERGE
6. Generation of data for several tables from different database schemes
7. Different generation types for each field including list, random and incremental generation, generation into two and more fields simultaneously
8. Ability to use SQL query results as a list of values for data generation
9. Ability to preview the generated data
10. Automatic control over referential integrity for linked tables
11. Ability to disable triggers of the generated tables during the generation process
12. Wide variety of generation parameters for each field type
13. Ability to set NULL values for certain percent of cases
14. Ability to save all generation parameters set on current wizard session into a configuration file
15. Command-line utility to generate data using the template file
    

Enhancements:

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

Requirements:

• 300-megahertz (MHz) or higher Pentium II-compatible processor; 600-MHz or faster processor recommended
• Microsoft Windows NT4 with SP4 or later, Microsoft Windows 2000, Microsoft Windows 2000 Server, Microsoft Windows XP, Microsoft Windows 2003 Server, Microsoft Windows Vista
• 64 MB RAM (128 MB or above is recommended)
• 20MB of available HD space for program installation
• Super VGA (800x600) or higher-resolution video adapter and monitor; Super VGA (1024x768) or higher-resolution recommended
• Microsoft Mouse or compatible pointing device
• Oracle Client 8.1.7 or higher
• Possibility to connect to any local or remote Oracle server