Data Loader Version History

• Uses the latest MySQL libraries to connect to the latest MySQL 8 database
• Supports caching_sha2_password authentication protocol for MySQL connections
• Delete synchronization — Data Loader can now delete rows in the target table that don't exist in the source table
• Enhanced user interface
• Bug fixes

• Convert Views between Oracle, MS SQL Server and MySQL
• Enhanced and refreshed user interface
• MSSQL Identity Insert is now supported
• Bug fixes and many other enhancements

• Increased number of compare columns for the UPSERT and INSERT feature
• Auto selection of primary key columns for the UPSERT and INSERT feature
• Enhanced UI
• Bug fixes and many other enhancements

• Database Viewer added to view target database tables and data
• You can now change source or target database usernames, passwords, and other information for existing sessions
• Data Loader now remembers your last database connection settings
• Enhanced Data Loader Scheduler management

• Bulk Loading added for Oracle, MySQL and MS SQL Server databases — loads millions of rows at blazing speed
• SQL Dump target sessions can now be saved and scheduled to execute at specified intervals
• No more need for a MySQL ODBC driver — Data Loader now uses the MySQL library directly
• Improved data type matching
• Many enhancements and bug fixes

Support 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
Data Loader now also supports the BULK INSERT method to load data into MS SQL Server databases. This method greatly improves performance, loading millions of rows in a fraction of the time.

UPSERT and INSERT features were added. Data Loader can now be used to synchronize data from any source database to any target database.

• UPSERT — updates the matching row in the target table, or inserts a new row if no matching row exists.
• INSERT — inserts a row in the target table only if a matching row does not already exist.

Note: make sure you have a primary key and index defined on the matching columns in the target table, otherwise loading will progress slowly when UPSERT or INSERT is selected.

For a visual explanation of the UPSERT and INSERT loading options, see the UPSERT and INSERT guide.

• Excel support has been added — you can now convert data from an Excel worksheet to any of the supported databases

• Full editing feature added — you can now edit or delete column mappings of saved sessions

• You can now create SQL dump files from any source database
• SQL dump files are useful when you need to load data into MySQL Server, Oracle or MS SQL Server where a direct connection isn't available

Folder Polling / Folder Watch
Data Loader watches for files in a folder at specified intervals, then loads data from filenames matching a specified pattern into tables automatically. See the Folder Polling guide for details.

• The only tool available on the internet for loading data by polling a folder
• Support for MS Access 2007 and MS SQL Server Express Edition
• Watch progress while running saved sessions
• Many other enhancements

• Load data into MySQL databases hosted on shared web hosting easily
• You can now change and choose the destination table names
• Load from multiple CSV / delimited flat files to multiple tables in one session
• More enhanced column mapping
• Microsoft SQL Server is now supported
• Transformation is supported with the help of views