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.