EMS logo

Products Navigation

Data Export for SQL Server

Our Partnership Status

Microsoft Certified Partner
Oracle Certified Partner
Embarcadero Technology Partner

EMS Data Export for SQL Server

On-line Documentation

Version history


 

Product name

Version

Release date

Data Export for SQL Server

Version 3.6.0.1

January 28, 2013

Data Export 2011 for SQL Server

Version 3.3.0.1

February 17, 2010

Data Export 2007 for SQL Server

Version 3.2.0.1

February 25, 2009

Data Export 2007 for SQL Server

Version 3.1.0.1

May 22, 2008

Data Export 2007 for SQL Server

Version 3.0.0.1

August 21, 2007

Data Export 2005 for SQL Server

Version 2.3.0.1

October 30, 2006

Data Export 2005 for SQL Server

Version 2.2.0.1

May 4, 2006

Data Export 2005 for SQL Server

Version 2.1.0.1

August 18, 2005

Data Export 2005 for SQL Server

Version 2.0.0.1

April 20, 2005

MS SQL Export

Version 1.7.0.1

December 26, 2004

MS SQL Export

Version 1.6.0.1

June 9, 2004

MS SQL Export

Version 1.5.0.1

January 28, 2004

MS SQL Export

Version 1.1.0.1

September 15, 2003

MS SQL Export

Version 1.0.0.1

July 15, 2003

 

 

Full version history is available at http://www.sqlmanager.net/products/mssql/dataexport/news

 

 

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

 

Version 3.5.0.1

 

  • Added the possibility to export data to MS Access 2007 (*.accdb Microsoft Access Database Engine 2010 Redistributable is required).
  • Added support of Microsoft SQL Server 2012
  • 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.
  • 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.
  • Other improvements and bugfixes.

 

 

 

Version 3.4.0.7

 

 

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

 

 

Version 3.3

 

  • 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

 

 

Version 3.2

 

 

  • 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

 

 

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

 

 

 

Version 3.0

 

Basic features:

  • Export to 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
  • Unicode support. Now you are able to export Unicode data
  • 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
  • The source code of the utility has been significantly optimized, running speed increased
  • The 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 bug-fixes

 

Scroll to top

 

 

Version 2.3

 

  • The amount of memory consumed is significantly decreased when exporting large files
  • Now the databases are sorted in lists
  • When truncating source field names the fields with identical names could appear in DBF file. Fixed now
  • The ability to set the Connection Timeout parameter added
  • Now it is possible to tune the performance via the Cursor Location option
  • The "login failed" message used to appear if the database name contained the dot ('.') symbol. Fixed now
  • Some minor improvements and bug-fixes

Scroll to top

 

Version 2.2

 

  • Now connection to SQL Server 2005 works correctly
  • 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 &lt; &gt; &quot; &amp; correspondingly
  • Added the ability to set the template file in the command-line for the GUI version; now the list of databases can be sorted
  • Several improvements in the GUI interface
  • Fixed a problem with extra delimiter symbols at the end of the header lines when exporting to CSV format
  • Fixed a  problem with extra delimiter symbols at the end of the record lines when exporting to Clipboard
  • Fixed a bug concerned with incorrect loading of SQL queries from template files
  • Fixed a  bug that did not allow one to set the sheet height, scope and width when exporting to PDF format
  • Fixed a bug that did not allow one to save the Width and Align property values to the template file when exporting to PDF format
  • Fixed the bug that caused the EOleSysError which often emerged during export to MS Access when creating a new database file (*.mdb)

Scroll to top

 

Version 2.1

 

  • Fixed the bug with filling "Selected Tables" list after loading template files
  • The bug with changing the width of fields during the export into PDF format has been fixed
  • Now the utility exports long text data into MS Access Database correctly
  • Added a possibility to export data into MS Access Databases secured with a password
  • "Allow Captions" checkbox has been moved from panel "Captions" to the upper common panel
  • Decreased processor loading while executing long export operations
  • Added Portuguese language support

Scroll to top

 

Version 2.0

 

Basic features:

and more...

Scroll to top

 

Version 1.7

 

  • The problem related to the "Export Only" option has been solved. Now you can export any required quantity of records
  • We have fixed the bug with exporting NULL values into DBF files and SQL scripts
  • The bug with filling "Selected Tables" list on the second step of wizard is fixed
  • Solved problems related with memory leaks
  • Some minor visual improvements and bug-fixes

Scroll to top

Version 1.6

 

  • Implemented the major integration ability between our the Query and Data Export products. Now you can export query results from any Database Query utility using the functionality of our Data Export utilities. All you need is to install version 1.6 of the corresponding Data Export utility (i.e. you need to install SQL Server Export 1.6 to export query results from SQL Server Query 1.6). The Export Data button will appear on the main toolbar of the Database Query utility
  • Now the Data Export utility displays description of all query errors when checking query correctness
  • With this version the Data Export utility requires a confirmation when you try to abort the export process. This feature can help you to avoid casual aborts of the export process
  • Fixed a bug that caused an error when rolling back changes in a query
  • Some small improvements and bug-fixes

Scroll to top

 

Version 1.5

 

  • Now you can add notes and hyperlinks to the Excel documents you create
  • Implemented an ability to make your data reports more attractive by adding charts based on exported data to the Excel documents you create
  • Implemented styles on export to Word/RTF. Now you can assign different styles to the document header, footer, caption, and data areas
  • Now you can use strip styles for data columns and rows on export to Word and RTF
  • Now console applications report about the export process
  • Some small improvements and bug-fixes

Scroll to top

 

Version 1.1

 

  • Support of BLOB fields
  • Support of Unicode data

Scroll to top

 

Version 1.0

 

Basic features:

  • Export to 12 most popular formats: MS Excel, MS Word (RTF), HTML, XML, TXT, DBF, CSV, SYLK, DIF, LaTeX, SQL and Clipboard
  • All SQL Server data types supported
  • Export from tables selected from different databases on one host
  • Adjustable parameters for each exported table, including: type and name of the result file, fields for export, data formats for all exported fields or for certain fields only, header and footer of the result file, column captions, width and alignment, and specific parameters for export to MS Excel, MS Word (RTF), HTML, XML, TXT, CSV and SQL
  • Possibility of saving/restoring export parameters to/from a template file
  • Command-line utility to export data using the configuration file, which contains connection options, tables and queries, and template files with all the export options

and more...

Scroll to top

 

 

 


See also:

What's new