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

EMS Data Export for SQL Server Changelog

What's new in EMS Data Export for SQL Server 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 SQL Server 3.7.2 Build 50001 (Aug 11, 2017)

  • BLOB fields can be exported to Base64 strings for text formats now.
  • Support for MS Access 2016 has been added.
  • Automatic search for MS SQL servers in the network has been improved.
  • 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 SQL Server 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 SQL Server 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.
  • Connecting to a server using SQL Server Native Client 2008 caused the error. Fixed now.
  • The "Connection Timeout" parameters were not applied. Fixed now.
  • Other minor improvements and bugfixes.

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

  • The speed of export to CSV, Text and XML formats has been considerably increased.
  • 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.
  • 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 SQL Server 3.3.0.1 (Nov 30, 2011)

  • Autofill host list option is added
  • When exporting from a SQL query, the query text can be added both to Header and Footer
  • Some visual changes are introduced; the sizes of forms/form parts are saved now
  • Fixed the bug, connected with writing the rows number to the DBF file header
  • It is now possible to define size and decimal for float fields when exporting to the DBF file
  • An error occurred on exporting more than 65536 records to Excel 97-2003. Fixed now
  • Decimal fields used to be exported improperly. Fixed now
  • Some other improvements and bugfixes

New in EMS Data Export for SQL Server 3.2.0.1 (Nov 30, 2011)

  • The utility now supports SQL Server 2008
  • When exporting data to SQL Script, BLOB (MEMO, BLOB, CLOB, etc.) data is formatted according to the destination server syntax
  • 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 SQL Server 3.1.0.1 (Nov 30, 2011)

  • Added the possibility to select file encoding when exporting to TXT (ANSI, OEM, MAC, UTF8, UTF16, UTF32)
  • Export to SQL script: if the source DBMS is selected as the destination server, the syntax of the CREATE TABLE statement completely complies with the source DBMS specifications
  • Export to SQL script: added the possibility to generate the 'IDENTITY_INSERT' SQL statement for export to MS SQL script
  • Now the 'Destination Directory' value is saved to the template and is restored when the template is loaded
  • The DBF files created by the utility were larger in size than required, as the size of all created char fields was set to 254. Fixed now
  • Other minor improvements and bug-fixes

New in EMS Data Export for SQL Server 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 SQL Server 2.2 (May 17, 2006)

  • Ability to connect through SSH and HTTP tunnels, other improvements and bugfixes