Online Documentation for Data Export for PostgreSQL

Version history

 

  Version 3.7.4

 

• Support for PostgreSQL 13 implemented.
• Added support for MySQL 8.
• Resolved error of connecting to SQL Server with TLS 1.2.
• Erroneous table name in SQL output fixed.
• Invalid call of procedures fixed.
• Other minor fixes.

 

  Version 3.7.3

 

• 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.

 

  Version 3.7.2

 

• 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.

 

   Version 3.7.1

 

• Support of the latest version of OpenSSH added.
• Memory usage has been improved.
• The template was loaded incorrectly with Studio. Fixed now.
• Data from views was incorrectly exported in console version. Fixed now.
• Now timestamp format in exported file name can be adjusted.
• User-defined field formats were not loaded from the template. Fixed now.
• Many other improvements and bug-fixes.

    Version 3.7.0.1

 

• 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.
• Passive connection mode is implemented when uploading file to FTP-server.
• 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.
• 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.

 

 

Version 3.6.0.1

 

• 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.
• Exporting to Access caused the loss of the decimal number precision. Fixed now.
• Other minor improvements and bugfixes.

 

 

Version 3.5.0.1

 

• Added the possibility to export data to MS Access 2007 (*.accdb Microsoft Access Database Engine 2010 Redistributable is required).

• Now the Help file is opened in the selected language of the program.

• Added the context menu for SQL Query Editor: Copy, Paste, Select All, Save as default query.

• Added the possibility to save and copy the Export Process log to the clipboard.

• There was a memory leak when exporting to Excel 2007. Fixed now.

• When launching two or more instances of the export console simultaneously specifying an individual log file for each instance, the log file was created for the first instance only. Fixed now.

• When exporting more than 2 GB of data to MS Access, a user-friendly error message is generated.

• The Export Process log did not support Unicode characters. Fixed now.

• Other improvements and bugfixes.

 

 

Version 3.4.0.7

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.

 

 

Version 3.3

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
• Some other improvements and bugfixes

 

 

Version 3.2

 

• The utility now supports PostgreSQL 8.3
• 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
• Connecting to PostgreSQL resulted in error, if a user was lack of rights for 'template1' database. Fixed now
• When a template was used for export, tables weren't displayed at Step 5. Fixed now
• Some other improvements and bugfixes

 

 

Version 3.1

 

• 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

 

Older version history is available at http://www.sqlmanager.net/products/postgresql/dataexport/news

 

---