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

EMS Data Import for SQL Server Changelog

What's new in EMS Data Import for SQL Server 4.0.0 Build 55675

Jun 6, 2022
  • Added support for dark theme.
  • Unicode object names support.
  • Improved support for the latest server versions.
  • Added data preview for MS Access, DBF and XML Data packet formats.
  • Optimized work with XML, DOCX, XLSX, XLS, ODS, ODT files.
  • In some cases, the console version shut down with a critical error. Fixed.
  • Other fixes and improvements.

New in EMS Data Import for SQL Server 3.8.3 Build 52018 (Dec 31, 2018)

  • Improvements and fixes in the console version, fixes of data import errors in the GUI version and more

New in EMS Data Import for SQL Server 3.7.0 Build 44144 (Jun 9, 2014)

  • Import rate is increased due to use of multithreading.
  • Data Import for PostgreSQL. The possibility to choose schema to create a new table is implemented.
  • Data Import for PostgreSQL. For server versions 8.1 or higher it is possible to get the list of databases from postgres database.
  • XML. Added the possibility of manual and automated identification of the type of the imported XML-file.
  • Now log contains information about the string number where the error occurred.
  • When importing from several files their logs are located at different tabs, while the main log contains general information about these processes.
  • DBF. Wrong identification of Integer type fields. Fixed now.
  • Data Import for SQL Server. "Keep identity" option did not work. Fixed now.
  • DBF. Data Import for MySQL. National characters were imported incorrectly. Fixed now.
  • yyyy-mm-ddThh:nn:ss format was recognized incorrectly. Fixed now.
  • HTML. When importing from HTML file with the links the application froze. Fixed now.
  • Data Import for MySQL. CSV. Errors in Native mode - CSV insert. Fixed now.
  • Other improvements and bugfixes.

New in EMS Data Import for SQL Server 3.6.0.1 (Jul 10, 2012)

  • Now the imported field value can be replaced with the following values: current date, current time, current date and time, the full name of the imported file, the short name of the imported file.
  • Now each imported field value can be processed using MS JavaScript statements.
  • The new import type is added for Firebird Servers. It uses an External table and can increase the import speed.
  • Now the console versions of Data Import use a localization selected in the GUI-version.
  • Now when importing to a new table, the length of string fields is calculated.
  • Added the "Import Empty Rows" option. If this option is not selected, empty rows are not imported.
  • Added the "Auto Trim Values" option. It allows to trim leading and trailing whitespace from the imported values.
  • Other improvements and bugfixes.

New in EMS Data Import for SQL Server 3.5.0.1 (Nov 30, 2011)

  • Added the possibility to rollback the transaction, if an error occurs.
  • The interface of the third step for all types of the imported files is uniformed now.
  • Import console. Now the import process information is displayed after certain time intervals.
  • Data Import Wizard. Now the import process information is displayed after certain time intervals.
  • Now localizations are loaded when the language directory is changed.
  • On opening a new field editor is filled in with default values now.
  • Now when importing to a new table, it is possible to determine the length of the string field by default.
  • Excel 2007. Added the possibility to configure Ranges when importing from Excel 2007, the same as importing from Excel 2003.
  • Excel 2007. Import speed is increased.
  • XML Data packet. Added the possibility to select the file encoding.
  • Access. Added the dialog for entering a username.
  • XML. Importing to a new table caused an AV error. Fixed now.
  • Excel. Using the range of rows in Map caused the incorrect data import. Fixed now.
  • Excel. When parsing a file with a field containing the SUM function with one argument, an error occurred. Fixed now.
  • Excel. When opening the Map Range editor, the data in it displayed incorrectly. Fixed now.
  • Data Import for MySQL. Fixed the critical bug in the Native mode.
  • Data Import for SQL Server. Fixed the bug connected with the autogeneration of values.
  • Data Import for PostgreSQL. When importing string data into the integer column, no error message displayed. Fixed now.
  • Some other improvements and bugfixes.

New in EMS Data Import for SQL Server 3.4 (Nov 30, 2011)

  • Added the support of Microsoft Office Access 2007 files.
  • The work with data is more convenient now. Templates for basic date formats are added.
  • Now when importing from an Access file to a new table, the structure of any Access table from a file is created.
  • Added the support of complicated date templates: mmm dd yyyy hh:nn:ss:zzzAP or yyyy-mm-ddThh:nn:ss.zzz.
  • Fixed a memory leak error which occurred when importing from large text files (CSV, TXT) in the Native mode of the utility (for Data Import for SQL Server and Data Import for InterBase / Firebird).
  • Fixed an error connected with the display of views with names in the lower register (for Data Import for InterBase/Firebird).
  • Now it is possible to set BigInteger (64bit, 19 Decimal digits) values for the generator at step 5 of the utility.
  • Some other improvements and bugfixes.

New in EMS Data Import for SQL Server 3.3 (Nov 30, 2011)

  • Added the possibility to automatically form fields when importing from TXT, CSV and XML formats to a new table.
  • Now the user can choose the necessary encoding, including UTF8, when importing from DBF files.
  • It is now possible to map more than 256 columns when importing from MS Excel 2007 (the maximum number is 16384, it is Excel 2007 restriction).
  • The console version now forms a more informative log file.
  • Some visual changes are introduced; the sizes of forms/form parts are saved now.
  • Added the possibility to save settings of the previous import procedure: formats, import mode, etc.
  • Fixed the "Object table name is in use" error occurred during table recreation (InterBase/Firebird).
  • The support of date formats is expanded, the YYYYMMDDHHMMSS format is now supported (SQL Server).
  • Fixed an error occurred when creating tables which contained _ in their name (DB2).
  • Other minor improvements and bugfixes.

New in EMS Data Import for SQL Server 3.2 (Nov 30, 2011)

  • Added the possibility to create separate tables for each source data file. The table structure is built on the basis of the source data analysis.
  • It is now possible to specify the source data charset when importing TXT and CSV files.
  • The ability to set correspondences between source data and existing table fields is implemented. This correspondence is based on the identity of the source columns’ and destination table fields’ names.
  • Added the possibility to choose the file character set (None, OEM, ANSI) when importing data from DBF files.
  • SQL Server 2008 support is implemented.
  • PostgreSQL 8.3 support is implemented.
  • Destination table fields' types are now displayed. (DB2)
  • The "Automatically reconnect when connection is lost" option is added. (MySQL)
  • Added the possibility to set the Connection Timeout parameter before connecting to the host. (SQL Server)
  • Importing data in the Universal mode resulted in error. Fixed now. (DB2)
  • Using "-log" parameter in console versions used to result in error. Fixed now.
  • Other minor improvements and bugfixes.