Version History

Version 2011.03

Fixed an issue with generation of numeric values in a range with a difference of 1. e.g. Random value between 0 and 1.
Fixed an issue with connecting to a MySQL 5.5.12 database (Bad Handshake error).

Version 2011.02

Changed type group of the MS SQL Server SQL_Variant data type from Exact Numeric to String.
XML data types will by default retrieve from the installation folder\blobs\xml\*.xml. This xml folder was available in previous versions.
Added the option to automatically associate or dissociate named generators in an existing project.
Selection of file values and list values with selection mode "sequential" now start with the first value in the list or file.
Added support for using special characters ], ) and } in constants of a expression. You can now use these characters in combination with a escape character.
Fixed an issue with generating numeric values for money data types in MS SQL Server databases.
Fixed an issue with generating large numeric values.

Version 2011.01

Removed "Generate test data" setting in table settings pane. You can now select the tables you wish to fill in a dialog that appears right before you start generating data.
Fixed an issue with inserting BLOBS for Oracle databases.
MS SQL Server computed fields were displayed as "AS". Fixed.
Preview data. This new feature shows you per table a quick/realtime preview of the data to be generated.
New PostgreSQL drivers ensure greater stability.
Added support for incremental values to the "Random text using expression" generator. For example: [K]I(1,1,5). This will generate "K00001", "K00002" etc.
New projects will now default be created in your "My Documents" folder.
Generated SQL file will now default be placed in your "My Documents" folder.
Added from and to date validation to the date/time generator.
Repeat value for (x) rows is a new generator setting for most fill types. This will ensure that a generated value gets used a number of times before generating a new value.
Timeout functionality added for data generation.
Schema names are added to the table's name now.
Fixed a bug with the last changed generator setting not being saved.
Fixed a bug with generating test data for fields with spaces in the name.
New fill type: "Value from query". Define a custom query and values from the query results will be selected when generating data.
Pre and post generation scripts can now be specified in the Project settings dialog.
New fill type "Value from view". A view and view column can be selected and values from the view data will be selected when generating data.
New generic fill types: Incremental date, Random file from directory, Incremental number.
Added a command line utility.
New fill type: Formula. Formulas can be specified to gather information from other fields as well as mathematical formulas.
Added horizontal scrollbars to the lists of tables so that long table names are readable.
Fixed Access violations when using selected parent column where more than one parent exists.
When selecting "Value from table" it gave an unsorted list of available tables. This list is now sorted.
In the Project settings dialog, the stored database connections was not displayed.
Enhanced generator "Random text using expression". You can now specify L for Letters. It will use any Uppercase or Lowercase letters. eg. L(4)
Fixed problem where NULL values were inserted wrongly.
PostgreSQL 9 support added.
Added the option to define the number of inserts per transaction.
Added support for named generators. A named generator is a set of data generation settings. For each field you can select a compatible generic fill type or a compatible named generator.
New "Select mode" generator setting. For each list based generator you can now specify to select a random item from the list (Random) or to step through the list (Sequential).
Redesigned Project settings dialog. New options tree.
New CSV files (such as banknames.txt, companynames.txt etc were added.
Removed data tables functionality. You can now directly select CSV files in the "Data directory". You can select your "Data directory" in the Options dialog.
New search table/column functionality. Useful for large projects.