November 1st, 2011Support for Constraints and Indexes:
· Data Loader 4.1 supports Constraints and Indexes. It can Export and Import Primary Keys, Unique Keys, Foreign Keys, NOT NULL and Default Values.
BULK INSERT For Microsoft SQL Server:
· Now Data Loader also supports BULK INSERT method to load data into MS SQL Server databases. This method greatly improves the performance and one can load millions of rows in very less time.
November 1st, 2011· UPSERT and INSERT features are added. Now Data Loader can be used to synchronize data from any source database to any target database.
UPSERT:
· This feature will update row in the target table if a matching row exist otherwise if the matching row does not exist it will insert a new row.
INSERT:
· This feature will insert a row in the target table only if the matching row does not exist.
December 15th, 2009· Excel support has been added. Now you can convert data from Excel worksheet to any of the supported databases.
October 8th, 2009· Full Editing feature added. Now you can edit, delete column mapping of saved sessions.
June 10th, 2009· SQL Dump files support is added
March 20th, 2009· Many enhancements have been made in loading data from CSV / Delimited Text files into databases.
· More connection options for connecting to MySQL.
May 16th, 2008· Support for MS-Access 2007 and and MS-SQL Server Express Edition.
· Now watch progress while running saved sessions
· Many other enhancements
· Folder Watcher ( Now load files in databases as it arrives in a folder)
· Support for MS-Access 2007 Databases
· Support SQL Server 2005 Express Edition
· View progress when running saved Sessions
· Many more enhancements