We are pleased to announce the new version of EMS Data Generator - an excellent tool for generating test data to database tables. You can download EMS Data Generator for InterBase/Firebird from the following link: http://www.sqlmanager.net/products/ibfb/datagenerator/download Product Key Features Unicode support User-friendly wizard interface Ability to save and edit generated data in the SQL script without executing queries on the server Ability to select different types of data insertion for Firebird 2.1: through INSERT, UPDATE OR INSERT or MERGE Support of all data types including BIGINT in Firebird 1.5 and BOOLEAN in InterBase 7.0, support of fields of domain-based types Different generation types for each field including list and random generation, generation into two and more fields simultaneously Ability to use SQL query results as a list of values for data generation Ability to preview the generated data Automatic control over referential integrity for linked tables Ability to disable triggers of the generated tables during the generation process Ability to set NULL values for certain percent of cases Ability to save all generation parameters set on current wizard session into a configuration file Command-line utility to generate data using the template file What"s new in Data Generator 3.0? Unicode support is implemented. Added new options for data generation to SQL script: BLOBs and arrays are dumped into to a separate file (for IB/FB); SQL script can be appended to an existing file; Added the possibility to select the data insertion type: INSERT, UPDATE OR INSERT (for Firebird), MERGE (for Firebird and Oracle). Added options allowing you to disable triggers associated with tables during data generation (for IB/FB, SQL Server, Oracle). 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. Added options for generating data into dependent fields with the relation 1:n (n records will be generated into the dependent table field for each record of the primary table). Implemented data generation into fields of domain-based types (for IB/FB). Data generation is now performed within a separate thread. Other improvements and bugfixes. We hope you"ll enjoy working with our products!
Source: http://www.sqlmanager.net/products/ibfb/datagenerator/news/1360