Data Migration Tool

Convert your databases in minutes. In just a few simple steps, Data Loader can convert tables, schemas, constraints, indexes, and data. It also supports auto increment columns, and saves you the time of writing your own migration programs.

Using Bulk Loading, Data Loader can load millions upon millions of rows in just a few minutes — it leverages vendor native libraries to make it as fast as possible.

Version History

New Version 4.7 released. Download Free Trial Version Now

Version 4.7

Increased number of compare columns for UPSERT and INSERT
Auto selection of primary key columns for UPSERT and INSERT
Bug fixes and other enhancements

Version 4.6

Database Viewer added to view target database tables and data
You can change connection settings of existing sessions
Data Loader now remembers your last database connection settings
Enhanced scheduler management

Version 4.5

Bulk Loading added for Oracle, MySQL, and MS SQL Server — loads millions of rows at blazing speed
SQL Dump target sessions can now be saved and scheduled
No MySQL ODBC driver needed — uses MySQL Library directly
Improved datatype matching
Many enhancements and bug fixes

Version 4.1

Support for Constraints and Indexes — exports/imports Primary Keys, Unique Keys, Foreign Keys, NOT NULL and Default values
BULK INSERT for Microsoft SQL Server — greatly improves performance for large loads

Version 4.0

UPSERT and INSERT features added — synchronize data from any source to any target. UPSERT updates a matching row or inserts a new one; INSERT only inserts rows that don't already exist

Version 3.6.1

Excel support added — convert data from Excel worksheets to any supported database

Version 3.6

Full editing feature added — edit or delete column mappings of saved sessions

Version 3.5

Create SQL dump files from any source database — useful when you don't have a direct connection to MySQL, Oracle, or MS SQL Server

Version 3.0

Folder polling — watches for files in a folder and loads matching filenames into tables automatically. More...
Support for MS Access 2007 and MS SQL Server Express Edition
Progress tracking while running saved sessions
Many other enhancements

Version 2.5

Load data into MySQL databases hosted on shared web hosting easily
Change and choose destination table names
Load from multiple delimited flat files to multiple tables in one session
Enhanced column mapping
Microsoft SQL Server support added
Transformation supported through views

Features

Load from Oracle Views (with transformation)
Wizard based
Save and schedule sessions
Fast speed, completely user friendly
No need to write any code
Repository database
MySQL database support
Select single or multiple tables to transfer

Convert multiple tables to text files simultaneously
Select or deselect columns while transferring
Change destination datatypes and widths
Automatic checking of datatype mismatch
Specify WHERE conditions to filter data
Rated best in category by many websites
Most popular product in Database Apps on download.com
Economical cost of just $99 for the Standard Version

Convert / Transfer Data Between

MS Access to MySQL
Oracle 7.3–11g to MySQL
Visual FoxPro/DBase to MySQL
Text to MySQL
MS SQL Server to MySQL

MS Access to MSSQL
Oracle to MS Access
Visual FoxPro to MS Access
Text to MS Access
MySQL to MS Access

MS Access to Oracle
Oracle 7.3–11g to MSSQL
Visual FoxPro/DBase to Oracle
Text to Oracle
MySQL to Oracle

MS Access to Visual FoxPro
Oracle to Visual FoxPro
Visual FoxPro to MSSQL
Text to Visual FoxPro
MySQL to Visual FoxPro

MS Access to Flat Text Files
Oracle 7.3–11g to Flat Text Files
Visual FoxPro/DBase to Flat Text Files
Text to Flat Text Files
MySQL to Flat Text Files