Softpedia >Windows >Internet >Servers >Database Utils >EMS Data Export for MySQL >  Changelog

EMS Data Export for MySQL Changelog

What's new in EMS Data Export for MySQL 3.7.3 Build 52803

Jul 19, 2019
  • SQL Server. Added support for Azure databases.
  • BOM mark is now optional for SQL format.
  • SQL Server. Connection to SQL Server 2017 with TLS is established correctly now.
  • Fields order was saved incorrectly into templates. Fixed now.
  • Automatic calculation of width for DOC fields has been improved.
  • Some parameters for XLS format were not saved in template. Fixed now.
  • PDF orientation was not applied correctly in the command line mode. Fixed now.
  • Renamed fields were not saved in template for CSV. Fixed now.
  • Queries were not loaded correctly in some cases. Fixed now.
  • Schema names were not exported into SQL format with "Apply to all exported objects" option enabled. Fixed now.
  • Other fixes and improvements.

New in EMS Data Export for MySQL 3.7.2 Build 50001 (Aug 11, 2017)

  • BLOB fields can be exported to Base64 strings for text formats now.
  • Adding of BOM is optional now.
  • The errors in using Before export script have been fixed.
  • The message about deleted tables was not added to the log. Fixed now.
  • The error of exporting view data has been fixed.
  • Dates were incorrectly exported to XLSX in some cases. Fixed now.
  • Data was not exported correctly to TXT with "User-defined column width" option on. Fixed now.
  • Many other improvements and bugfixes.

New in EMS Data Export for MySQL 3.7.0 Build 44145 (Jun 9, 2014)

  • DOCX. The possibility to insert images from BLOB-fields to the table is implemented.
  • XML. Export of binary data from BLOB-field with HEX and Base64 format is implemented.
  • Numeric template and date and time template formats refer to the standard Windows formats.
  • Data Export for Oracle. Support of Oracle12 is implemented.
  • Passive connection mode is implemented when uploading file to FTP-server.
  • Data Export for MySQL. When the application was idle for a long time, "MySQL server has gone away" error occurred. Fixed now.
  • Data Export for MySQL. When exporting data from a large table, "MySQL server has gone away" error occurred. Fixed now.
  • XLS. When adding the hyperlink to another *.xls file, at times the link turned out to be broken. Fixed now.
  • SQL. When inserting the large number of records, "Out of memory" error occurred. Fixed now.
  • Data Export for PostgreSQL. SQL. When trying to export query result containing 'left' function of varchar data type field to ORACLE syntax, the function execution result was exported as BLOB data type. Fixed now.
  • MDB, ACCDB. Integer type fields were exported as text. Fixed now.
  • CSV. The export to UTF-8 coded files did not work. Fixed now.
  • XML. When exporting data with spaces, ordinary spaces were replaced with nonbreaking spaces. Fixed now.
  • Other improvements and bugfixes.

New in EMS Data Export for MySQL 3.6.0.1 (Feb 4, 2013)

  • Added the possibility to upload the exported files to FTP server.
  • Added the possibility to add date/time to the exported file name.
  • Added the possibility to execute SQL scripts before and after exporting the object.
  • Now the program template is created as a single file.
  • Now the localization is also available in the console version.
  • Now the binary data can be exported as HEX.
  • Export to SQL. Added the possibility to create a single INSERT statement.
  • Export to Excel (xls). Now you can set the specified number of rows to split the exported data into the worksheets in Excel.
  • Now you can save changes to a template without recalling the save dialog.
  • Loading from a template caused SQL queries corruption. Fixed now.
  • Failed to connect through HTTP tunnel. Fixed now.
  • Other minor improvements and bugfixes.

New in EMS Data Export for MySQL 3.4.0.6 (Nov 30, 2011)

  • The console version now displays the progress of the export process.
  • The export into SQL format on Windows 7 resulted in the Access Violation error. Fixed now.
  • Sometimes NULL values were exported incorrectly. Fixed now.
  • When exporting into an existing table of MS Access, an error occurred. Fixed now.
  • When exporting into the PDF format, the right and center alignment worked incorrectly. Fixed now.
  • Now when exporting into PDF, lines with a large number of characters are split and placed correctly without overlapping the neighboring cells.
  • The interface language chosen for the utility was not saved. Fixed now.
  • Now the non-allowed characters in the automatically generated names are replaced by the underscore.
  • Some other improvements and bugfixes.

New in EMS Data Export for MySQL 3.2.0.1 (May 30, 2009)

  • Added the possibility to set page orientation when exporting data to MS Word 2007
  • When a template was used for export, tables weren't displayed at Step 5. Fixed now
  • Some other improvements and bugfixes

New in EMS Data Export for MySQL 3.0.0.1 (Aug 22, 2007)

  • Unicode support. Now you are able to export Unicode data (from SQL Server, MySQL and PostgreSQL databases).
  • Export from new formats is available now: MS Excel 2007, MS Word 2007, Open Document Format (Open Document Text and Open Document Spreadsheet), Generic XML with XSD schema
  • Now you can use parameters in data export queries. The parameters are prompted in interactive mode in the wizard. In the Console version query parameters can be set in the command line or prompted in interactive mode.
  • Utility source code significantly optimized, work speed increased.
  • Now you can select destination server (SQL Server, Oracle, MySQL, DB2, etc.) when exporting to SQL format. Result script will be generated in accordance with the specifications of the target server.
  • Wizard window is now resizable.
  • An error used to occur when exporting tables containing VARCHAR fields with the length of more than 255 symbols to MS Access. Fixed now.
  • Other minor improvements and bugfixes.

New in EMS Data Export for MySQL 2.2.0.1 (May 9, 2006)

  • Added the opportunity to connect through SSH tunnel. (MySQL, PostgreSQL, InterBase/Firebird)
  • Added the opportunity to connect through HTTP tunnel. (MySQL, PostgreSQL)
  • Now the connection to SQL Server 2005 works correctly. (MS SQL Server)
  • The support of all BLOB field types is implemented. (InterBase/Firebird)
  • The "Interpret HTML Tags" option is added to allow replacement of all special symbols. The symbols , ", & found in exported data (text) will be replaced with < > " & accordingly.
  • Added the ability to set the template file at the command-line for the GUI version; Now the list of databases could be sorted.
  • Several improvements in the GUI interface.
  • Fixed the problem with extra delimiter symbols at the end of the header lines when exporting to CSV format.
  • Fixed the problem with extra delimiter symbols at the end of the record lines when exporting to Clipboard.
  • Fixed the bug with incorrect loading of SQL queries from template files.
  • Fixed the bug that didn�t allow to set the sheet height, scope and width when exporting to PDF format.
  • Fixed the bug that didn�t allow to save the Width and Align property values to the template file when exporting to PDF format.
  • Fixed the bug that caused the following: when exporting memo type fields to MS Access, the data length after export always equaled the field length by adding subsequent spaces, even though the actual data length was shorter. Due to this the data from such fields could not be edited. (MySQL, PostgreSQL)
  • Fixed the bug that caused the EOleSysError which often emerged during export to MS Access when creating a new database file (.mdb).