v10.2 [Apr 7, 2010]
- Visual Query Builder has been dramatically improved. Now it can produce INSERT, UPDATE and DELETE statements as well as the SELECT statements containing subqueries and/or UNIONs.
Data Export wizard has been significantly improved:
- 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 Import wizard has been updated too:
- 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.
- Get SQL Dump: abilities to generate multi-row INSERT statements and specify output file encoding have been implemented.
- BLOB Viewer: Unicode support has been added to the Non-BLOB data grid.
