Version history
|
Product name |
Version |
Release date |
|
Data Export 2011 for SQL Server |
February 17, 2010 |
|
|
Data Export 2007 for SQL Server |
February 25, 2009 |
|
|
Data Export 2007 for SQL Server |
May 22, 2008 |
|
|
Data Export 2007 for SQL Server |
August 21, 2007 |
|
|
Data Export 2005 for SQL Server |
October 30, 2006 |
|
|
Data Export 2005 for SQL Server |
May 4, 2006 |
|
|
Data Export 2005 for SQL Server |
August 18, 2005 |
|
|
Data Export 2005 for SQL Server |
April 20, 2005 |
|
|
MS SQL Export |
December 26, 2004 |
|
|
MS SQL Export |
June 9, 2004 |
|
|
MS SQL Export |
January 28, 2004 |
|
|
MS SQL Export |
September 15, 2003 |
|
|
MS SQL Export |
July 15, 2003 |
Full version history is available at http://www.sqlmanager.net/products/mssql/dataexport/news
- 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.
- 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.
- 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.
- 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
- 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
- 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
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
- 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
- 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 < > " & 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)
- 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
Basic features:
- New user-friendly wizard interface
- Six languages available: English, French, German, Italian, Russian and Spanish
- Exporting to 15 most popular formats: MS Excel, MS Access, MS Word, RTF, HTML, PDF, XML, TXT, DBF, CSV, SYLK, DIF, LaTeX, SQL and Clipboard
- Exporting data from several objects from different databases on one host
- Exporting data from tables, views and queries
- Selecting fields to export and changing their order
- Adjustable parameters for each exported table and specific parameters for export to MS Excel, MS Word / RTF, MS Access, HTML, TXT, CSV, PDF, XML and SQL
- Possibility of saving all the export parameters specified within the current wizard session
- Command-line utility to export data using the configuration file
- Powerful visual options module
and more...
- 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
- 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
- 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
- Support of BLOB fields
- Support of Unicode data
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...
|
See also: |