January 20th, 2011Data 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.
· As usual, after adjusting the import process you can save all the settings to a template file for further using from the command line and/or on a scheduled basis.
· 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:
· Since now Data Export wizard on transferring data from Microsoft Access works only with a single database during a wizard session.
· This release has been successfully tested with 64-bit operating systems including Windows 7 x64.
December 23rd, 2009Data Import features:
· Now you can import data from Microsoft Office Excel 2007 and Microsoft Office Access 2007 file formats along with Microsoft Office Excel 97-2003, Microsoft Office Access, CSV, DBF, and Text files supported in the previous versions.
· Starting with this version you can import Text and CSV data files stored in different encodings.
· Now it is possible to empty target tables as well as execute custom SQL scripts before and after the import.
· An ability of using bulk-loading commands has been implemented (for MySQL, PostgreSQL, and Oracle). This feature can speed up the import process up to 10 times so it is recommended to use it always if possible.
· The wizard has been completely redesigned to improve the look and feel and increase the usability.
Data Export features:
· Support for Microsoft Office Excel 2007, Microsoft Office Word 2007, OpenDocument Spreadsheed, and OpenDocument Text file formats has been implemented.
· Now you can select the result file encoding (ANSI, UTF8, UTF16, UTF32, OEM, and Mac).
· The wizard also has been completely rewritten to improve the look and feel and increase the usability.
Data pump features:
· The conversion rules for fields and indexes become more intelligent, so starting with this version most of source databases from well-known DBMS can be transferred even with default settings (or with a small customization). Also the speed of data transfer has been significantly increased.
PHP Generator features:
· PHP Generator Wizard comes with a lot of new features including master-detail presentations, advanced picture management, custom formatting, client-side validators, data display partitioning, event-driven content management, export to Excel/Word/XML/PDF and a lot of other things.
· With all these features we decided to dedicate this wizard to a separate software product that should be officially released in a couple of weeks (however you can take a look at a demo website and see new features in action right now).
DBMS-related features:
· Starting with this version it is possible to connect to a remote server via SSH tunnel using a key-based authentication (in addition to the password-based authentication supported in the previous versions). To establish a remote connection in this way, you have to provide a private key (either in ssh.com or OpenSSH formats) and (optionally) a passphrase.
· This version also introduces support for both SSH-1 and SSH-2 protocols (whereas all the previous versions supported only SSH-1).
Other new features:
· An Italian localization is now included into the installation package.
· In addition to this, several bugs have been fixed and some other minor improvements and corrections have been made.
Find us on Google+
