Kelly Dires: "First let me say we are very impressed with Firebird Data Wizard, it was not only the fastest but also the easiest to use out of the six tools of this class tested".

Phillip Magger: "A word of congratulations. I think that your Firebird Data Wizard is some of the best stuff I have ever used. I was in search of an easy-used tool, and I found it. It is a good solution".

DBMS-related features:

A possibility of connecting to remote MySQL, PostgreSQL and Firebird databases using keyboard interactive SSH authentication has been implemented. This method provides for a multiple challenge-response dialog with the user in which the server sends a text query to the user, the user types in a response, and this process can repeat any number of times to ensure that the client is a human.

Picture 1. SSH Options: keyboard interactive authentication

The Update Existing Records option has been added to the Data Import module of Oracle Data Wizard. If this option is turned ON, the records will be either updated or inserted. Other servers this feature is available for are: MySQL, PostgreSQL 9.0+, Microsoft SQL Server, SQLite, and Firebird 2.1+.

Picture 2. Data Import: updating existing records

Other new features:

Starting with this version it becomes possible to send an email notification with attached log file after the importing. To enable this feature, you have to provide the email settings (outgoing mail server, login, password, etc). It is also possible to customize the email template according to your needs.

Picture 3. Email settings

New version allows you to import data from several files to a single table at a time. To import data in this way, enter the mask of the file names to the appropriate field. To see the list of matching files, use the button on the right of the control.

Picture 4. Import data from multiple files to a single table

The Column Builder for text files with fixed column width has been redesigned. Now to set the correspondence between table columns and areas of a text file, you can either input offset and width for each column directly into the controls, or define these values by clicking the left mouse button in the right area of the tool.

Picture 5. Column Builder for text files with fixed column width

Now it's possible to add current timestamp to the log file name using the %ts:TIMESTAMP_FORMAT% string template. Examples of valid datetime formats are:
'YYYY-MM-DD', 'YYYY-MM-DD-HH24-MI', 'YYYY-MM-DD-HH24-MI-SS', and so on.

Now it is possible to rename output columns in the result SQL script. To set a new target column name, enter a value to the Target column in the grid at the first step of the wizard.

You can also change the order of output columns using the appropriate commands of the popup menu or Ctrl+Up and Ctrl+Down shortcuts.

Picture 6. SQL Dump: target column order

Starting with this version it is possible to specify the SQL syntax the result script to be written on. This feature allows you to restore the dump contents to a table in a different database server such as MySQL, PostgreSQL, SQL Server, Oracle, Firebird, or SQLite.