SQL Maestro Group announces the release of PostgreSQL Data Wizard 9.12, a powerful Windows GUI solution for PostgreSQL data management.
The new version is immediately available at
Data Import: now you can import data from XML, 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. Also starting with this version you can import Text and CSV data files stored in different encodings.
Data Import: now it is possible to empty target tables as well as execute custom SQL scripts before and after the import.
Data Import: an ability of using the COPY command has been implemented. This feature can speed up the import process up to 10 times.
Data Import: the wizard has been completely redesigned to improve the look and feel and increase the usability.
Data Export: support for Microsoft Office Excel 2007, Microsoft Office Word 2007, OpenDocument Spreadsheed, and OpenDocument Text file formats has been implemented. Also now it is possible to select the result file encoding. This wizard also has been completely redesigned.
Datapump: 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.
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).
An Italian localization is now included into the installation package.
There are also some other useful things. Full press release is available at the SQL Maestro Group website.
This post has been migrated from a previous version of the PostgreSQL website. We apologise for any formatting issues caused by the migration.