v13.1 [Jan 7, 2014]
Data Wizards advanced to version 13.12
Dec 6, 2013
SQL Maestro Group is happy to announce the release of Data Wizard 13.12, a toolset of powerful utilities for managing your data. There are versions for MySQL, MS SQL Server, PostgreSQL, Oracle, SQLite, Firebird, DB2, SQL Anywhere and MaxDB.
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.
SSH Options: keyboard interactive authenticationPicture 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 .
Data Import: updating existing recordsPicture 2. Data Import: updating existing records
Other new features:
Data Import 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.
Email settingsPicture 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.
Import data from multiple filesPicture 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.
Column BuilderPicture 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.
SQL Dump has been significantly updated:
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.
SQL Dump: target column orderPicture 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.
SQL Dump: setting SQL syntaxPicture 7. SQL Dump: setting SQL syntax
Data Pump features:
Default data type mapping has been improved.
The "Use unidirectional cursors" option has been implemented (turned ON by default). Don't uncheck it until we recommend you to try this chance answering your support question.
Data Export: support for Json file format has been implemented.
Data Export to JSONPicture 8. Data Export to JSON
The Start Page has been redesigned in order to provide more comfortable access to program features and display the latest company news.
All the wizards now store their size and position.
In addition to this, several bugs have been fixed and some other minor improvements and corrections have been made.
v11.1 [Feb 3, 2011]
Data Import features:
- Starting with this version it becomes possible to import data from any database accessible via an ODBC driver or OLE DB provider, such as SQL Server, MySQL, Oracle, MS Access, Sybase, DB2, PostgreSQL, etc. Let's look through some details of the new feature:
- To import data in this way, you have to specify a connection string and select appropriate identifier quote characters to escape improper symbols and blanks in object names according to the source database (for example, double quotes for Oracle and PostgreSQL, backticks for MySQL, or square brackets for SQL Server and MS Access).
- This type of data import does not require the structure of source database to be identical with the structure of the target one. For example, data from a single source table can be imported to several different target tables and vice versa. This becomes possible because of an ability of using custom SQL queries as import data sources. Other benefits of this feature include restricting the transferred data by a specified criteria, limiting the number of records to be imported, and so on.
- Another (and for now the last) thing to note is that this kind of import completely supports BLOBs (if they are supported by the ODBC driver / OLE DB provider used).
- The Update Existing Records option has been added to the last page of the wizard. If this option is turned ON, the records will be either updated or inserted (available for MySQL, PostgreSQL 9.0 , Microsoft SQL Server, SQLite, and Firebird 2.1 ).
- Now it is possible to specify SQL scripts to be executed before and/or after data import to each table. The typical example of the feature usage is the data import to several SQL Server tables with autoincrement columns. In this case you need to execute SET IDENTITY_INSERT %table_name% ON and SET IDENTITY_INSERT %table_name% OFF before and after data import to the table accordingly.
- The log file provided by Data Import becomes more informative.
Data Pump features
- Starting with this version it is possible to define some naming conventions for transferring metadata objects. You can choose whether source schema name will be added to target table names, select desired name case as well as specify prefix and suffix for the target tables.
- New version allows you to restrict number of pumped records by means of specifying filter conditions, view source table data as well as count number of records in the source tables.
Other new features
- From now on the Data Export wizard uses a single MS Access database for all the exported tables/views/queries (doesn't create a separate database for each exported data source).
- This release has been successfully tested with 64-bit operating systems including Windows 7 x64.
In addition to this, several bugs have been fixed and some other minor improvements and corrections have been made.
v8.4 [May 14, 2008]
Version 8.4 features support for system tasks, command line options, a lot of improvements in PHP Generator and much more.
