What's new in Datanamic Data Generator for MS SQL Server 9.0.0
Sep 30, 2021- When connecting to a PostgreSQL database you now have the option to select a database from a list of available databases.
- Failure to connect to SQL Server databases in with different credentials after unsuccessful initial connection attempt is fixed.
- List with saved works/project in the Welcome dialog is no longer disabled by default anymore.
- Fixed: Entered value in a property editor not automatically saved when you resize the property editor.
- New project properties dialog with project name, project description, author etc. (this data will be added the the data generation plan report).
- Improved routine to determine the order in which data must be generated. From now in the routine also takes into account when you refer to a another table in your data generation settings.
- Save log now results in a plain text file.
- New data generator: value from table (use generated data).
- New: Generate a data generation plan report.
- Added extra checks to see if the data is correct for the field when the data is from an external source such as a text file/csv file.
- Fixed an issue with message 'table %%% already exists' when generating preview data.
- Fixed an issue with not emptying earlier generated values when starting a new data generation process.
- Fixed an issue with missing default values for the selected database type when creating a new project.
- From now on preview data will be generated for all tables when opening a project and right after creating a new project.
- Added SSL support.
- Fixed an issue with incorrect mapping of FLOAT columns in Oracle databases when loading the database.
- Fixed an issue with importing SQLite LargeInt columns.
New in Datanamic Data Generator for MS SQL Server 8.1.1 (Jan 21, 2021)
- Fixed issues connecting to Firebird 3 databases.
- Fixed an issue with "list index out of bounds" error when using generator value from parent table.
New in Datanamic Data Generator for MS SQL Server 8.1.0 (Jul 1, 2020)
- Fixed an issue with preview data generation for tables with one or more column associated with a domain.
- Fixed an issue with missing columns when reverse engineering PostgreSQL 12 databases.
- Fixed an issue with "missing large object" message when reverse engineering PostgreSQL databases.
- Table definition is shown in the table settings pane from now on.
- Faster generation of table preview data.
- From now on data for a foreign key column will always be picked up from generated data of the parent column.
- Fixed an issue with generating preview data for tables with string type primary key.
- New underlying method for storing data that will be needed later in the test data generation process.
New in Datanamic Data Generator for MS SQL Server 8.0.0 (Feb 18, 2020)
- Added Oracle 19c support.
- Fixed an issue with non visible dialog to enter your license code and key.
- New file format. Data generator plans made with older versions of the software will be converted automatically.
- New progress dialog.
- Faster generation of data that will be shown in the preview data pane.
- Added the option to add data generation comments for each column.
- Redesigned the main dialog.
- Improved presentation of data generation errors. Error messages can be copied now.
- Fixed an issue with flickering when opening a project.
- Added PostgreSQL 12 support.
- Bug with UTF-8 encoding for Oracle 9 in the Direct mode is fixed.
- Important column notes (e.g. columns is part of a unique index) are now displayed at the bottom of the column settings pane.
- Added auto expand/collapse functionality to the grid of columns.
- From now on you will see a link to the online check for updates page when there connecting to the updates server fails.
New in Datanamic Data Generator for MS SQL Server 6.1.0 (Jul 5, 2016)
- Fixed an issue with getting value from parent field when generating test data to an SQL file.
- Added the option to generate test data to multiple SQL files instead of only one file. One SQL file per table can be generated from now on.
- Fixed an issue with displaying preview data for foreign key field data. Quoted strings were displayed instead of unquoted strings.
- Fixed an issue with generated test data for foreign key field data when generating to SQL scripts. Quoted strings were generated instead of unquoted strings.
New in Datanamic Data Generator for MS SQL Server 6.0.0 (Jul 5, 2016)
- Added the option to use functions in expressions.
- Expressions are now available for date fields also.
- The first row was skipped when using data from an external source in sequential mode. Fixed.
- Added support for MS SQL Server 2014.
- Fixed an issue with the question and info dialog being displayed behind another dialog.
- Fixed an issue with Invalid floating point operation when doing a test run.
- Caption of labels in progress dialog displayed the wrong text for the the first seconds after the dialog became visible.
- Message about sample project when starting up the trial was not correct. Fixed.
- Wrong name displayed in main form when loading project. Caption of main form now displays "..." when loading or initializing a project.
- From now on temporary files and preview data stored in the appdata folder instead of the windows temp directory.
- Added the option to deactivate the software.
- Added the option to check for updates. You can do that via the menu Help | Check for updates. You can also configure the application to check for updates each time the application starts.
- Fixed an issue with the color of the toolbar. Sometimes the color of the toolbar changed on start up.
- Fixed an issue with a wrong order of child-parent columns in multi-column foreign key constraints when loading MS SQL Server databases.
- Improved routine to determine logical order for data generation (Self referencing relationships are treated different).
- Fixed a connection error when selecting the query/view column with "value from query" and/or "value from view".
New in Datanamic Data Generator for MS SQL Server 5.1.0 (Jul 17, 2013)
- Added the option to refer to values from other fields in the same record. e.g.: The following expression can be used when generating data fro field FullName ["FirstName" "MiddleName" "LastName"]. See sample project also.
- Fixed an issue with the installation of Datanamic Data Generator. An unnecessary submenu "Datanamic" was created.
- From now on the dialog to open the sample project is there every time you start the application.
- Fixed an issue when creating a new project. The message that a definition file is missing is not displayed anymore.
New in Datanamic Data Generator for MS SQL Server 5.0.0 (Mar 14, 2013)
- From now on you can select the tables you want to populate in the list of tables in the main dialog.
- Complete new user interface.
- Multiple data generation plans (projects) can be opened and edited at the same time.
- Auto highlight the column in the preview data grid when the corresponding field is edited or is selected.
- New "test run" option when generating test data. Do a full execution of the plan, or execute only a part (e.g. 10%) of the data generation plan.
- Field settings: Added the option for "synchronized selection" to the "select mode" combobox. Synchronized selection is available when your fill type is a table or a view. It means that the cursor in the table/view will not change for each field. If you do not set "synchronized selection" then the cursor will be moved each time data is fetched (so for each field).
- You can now specify a random or sequential select mode when your fill type is "Value from Parent Field".
- The number of generated preview records will not exceed the specified number of rows to generate for that table anymore.
- Generated or selected empty strings (for fill type value from lists for example) are now inserted as NULLs by default.
- Improved error messages when generation of preview data fails.
- Added the option to fill a column with an exact numeric data type from a CSV file or from a list.
- Use custom filters when selecting the tables you want to add to your project.
- Now easily navigate to related tables from the table settings pane.
- New option to turn off automatic sample data generation.
- New select fill type combo box for easier selection of generator.
- Added support for MS SQL Server 2012 databases.
- Intelligent determination of number of records to generate.