 |
DB Data Generator
Quickly Generate Meaningful Test Data
|
Version History
Version 2.2.1
- No values were generated for foreign key fields. Fixed.
- When setting Empty table for one table, it was done for all tables. Fixed.
- With PostgreSQL generating NULL values for BIT and BIT VARYING fields
resulted in errors. Fixed.
- When generating data for a child table and the parent table was not in the
project this could result in access violations. Fixed.
Version 2.2.0
- The ordering of tables for data generation is now based on the tables
selected in the project.
- The tables in the main screen are now sorted by table name.
- Added support for MS SQL Server uniqueidentifier data type.
- When populating auto increment fields, and a fill type other than [None]
was used, the number was not generated. Fixed.
- Added the option to disable triggers.
- When generating SQL script the generated script contained errors if the
name of a column was part of the name of another column. Fixed.
- When using the fill method "DBTable" the reference to the table and column
was lost after refreshing the project.
Version 2.1.0
- Added pre and post scripts (You can edit these scripts in the Project
settings dialog).
- Added validation of masks/expressions.
- Fixed a bug with column with a UNIQUEIDENTIFIER data type. No fill types
were available for this data type.
- Fixed a problem with determining the table order for insertions for
MySQL 5.1 databases.
- Fixed problems when connecting to a MS SQL Server database with a user with
limited rights (sometimes columns were not visible in the main window).
- Improved validation of data generator settings for MS SQL Server 2005
databases (Unique constraints are recognized now and used for validation).
- Fixed a problem with duplicate NOT NULL constraints (on column level and on
table level) for Oracle databases.
Version 2.0.0
Changes compared to version 1
- Added support for schemas/owners. You can now connect using a schema/owner
(optional). Schema/owner is visible in the list of tables.
- New: Fill table with data from another table in the database.
- Fixed a bug with inserting data for column with names with spaces in it
(applies to all supported databases).
- Improved fine-tuning of default configuration for field settings.
- Extended validation of settings.
- Performance improvements when inserting data in MS SQL Server, Oracle and
MySQL databases (Now using unidirectional queries).
- When creating SQL INSERT scripts, the DATE/TIME data types will now be
formatted using the format as specified in the Options dialog.
- Fixed problems for table names with mixed case.
- Solved problems logging in to password protected MS Access databases.
- Added MS Access 2007 support.
- Now Seed and increment by setting are default "1".
- Fixed problem with MS SQL Server 2005 Identity property in combination
with multiple schemas in one databases.
- Progress indicator when capturing database has been added.
- Included support for MySQL's YEAR, GEOMETRY data types.
- Included support for Oracle's BINARY_FLOAT, BIANRY_DOUBLE, ROWID and
UROWID data types.
- Included support for MS SQL Server's SYSNAME, UNIQUEIDENTIFIER,
SQLVARIANT, TIMESTAMP and XML data types.
- Included support for PostgreSQL's BOX, CIDR, CIRCLE, INET, INTERVAL,
LINE, LSEG, MACADDR, MONEY, PATH, POINT, BIT, BITVARYING and POLYGON data
types.
- Fixed a problem for inserting MS SQL Server data in tables with
UNIQUEIDENTIFIER and/or TIMESTAMP columns.
- Improved data generation for numbers with precision.
- Improved BLOB insertions for all supported databases.
- Fixed problems connecting to MS SQL Server and MS Access databases on
some Windows Vista systems.
- Improved insert statements in generated SQL file for MS SQL Server
SMALLMONEY, MONEY and BINARY columns.
- Fixed a problem with views being added to the project next to tables for
MS Access databases.
- Fixed a problem with Oracle TIMESTAMP columns being converted to VARCHAR2
columns.
- Corrected length setting for Oracle NCHAR and NVARCHAR data types.
- Fixed a bug in the Manage database connections dialog. The cancel button
still applied the changes.
- Faster loading of application under Vista.
- Changed tab order in the Welcome dialog.
- Fixed file association for Windows Vista in the setup program.
- Fixed a problem with the "Stored database connection" combobox. This entry
field was refreshed and set to right after selecting an item from
the list.
|
 |
| Single DBMS Edition: |
$ 129 |
| Multi-DB Edition: |
$ 259 |
DB Data Generator supports the following databases:
- Oracle
- MS SQL Server
- MS Access
- MySQL
- PostgreSQL
- InterBase
- FireBird
|
|