Data Loader

 

Data Loader

Data Loader the most easy and simple way to convert data between MySQL, MS SQL Server, Oracle, MS Access, FoxPro, Excel, CSV and Delimited Text Files 

Download Tour Buy

 

Forms Data Loader

The best & latest tool to load data in Oracle Apps 11i / R12 through Front End Forms. Load thousand of rows through Macros or Forms Record & Playback in Oracle EBS Forms or Web Based Forms in minutes

Download Buy More Info

Looking for a one-stop data loading tool online? You’re at the right place! We have the best tools for loading data in  Oracle EBS 11i/R12 through front end forms and also best in the class Data Migration tool.

Please visit our dedicated website for Data Loader for Oracle E Business Suite 11i / R12

Data Loader is a simple, yet powerful tool capable of Synchronizing, exporting and importing data between many common database formats.  If you wish to convert MS SQL Server, CSV or MS Access to MySQL, this is the best tool satisfying your specific needs effectively. The latest Data Loader Version  supports MySQL, Oracle, MS Access, Excel, FoxPro, DBF, MS SQL Server, CSV and Delimited or Flat Files. You can now easily convert Oracle to MySQL or MS SQL Server using this tool equipped with several unique and advanced features.

For example, while transferring, you can filter columns and specify WHERE conditions. Similarly, Data Loader supports full mapping of source columns to target table columns. Other notable features include bulk inserts, built-in scheduler, UPSERT and INSERT, folder polling, command line interface, Email notifications, Synchronizing etc.

 New Version 4.9.5 Released  (Download Free Trial Version Now) 20-Aug-2024

Our tool is the most powerful data migration tool available online, thanks to 17 years of continuous improvement and maintenance.

But you don't have to take our word for it; try it for free by downloading and testing it yourself!

dataloader screenshot

Compare the following features which you will not find in any other tool

  • Load data into any existing target table also with full Column Mapping
  • UPSERT and INSERT feature to synchronize source and target tables. More
  • Creates SQL dump files from any Source Databases
  • Folder Polling feature, monitors a specified folder and loads data automatically from changing CSV or Text files
  • Support Command Line interface to execute sessions from command line or other executable
  • Supports repository to easily manage all existing sessions
  • Comes with its own scheduler or you can use Windows Task Scheduler
  • Support Bulk Loading to load millions of rows faster
  • Migrates Indexes, Constraints and Default values
  • Migrates VIEWS as VIEWS or Tables to / from Oracle, MSSQL and MySQL
  • Can also be use to download and upload data to Microsoft Azure databases in the Cloud. More
  • Migrate data from your local databases to Amazon Cloud databases effortlessly.

New Features in Version 4.9.4

  • PostgreSQL support. Now you can migrate data to and from PostgreSQL using Data Loader
  • Bug fixes and enhancements

New Features in Version 4.9.3

  • Email Notifications: Now Data Loader will automatically send the session log to your email address always or whenever any issue occurs to keep you updated.


    dataloader email notifications
  • Bug fixes and enhancements

See Complete Version History

MySQL partner

data loader for oracle


Our Esteem Customers
* Apple Inc.
* Cannon
* Toshiba
* HP
* Fujitsu
* STC
* Motorola
* CapsGemini, India
* Quantum Corp, USA
* Dept. of Defense, Australia
* Lawrence Livermore
* National Laboratory, California
* ViableCom, Canada
* Results Radio
* True oil llc
* Optix
* LogicaCMG
* KPMG
* Siemens ITS

And many more…


Microsoft Partner



Customers Review
I really like the simplicity of Data Loader....  Kirsten

Dataloader is making my transfer job from Oracle to Text files very easy and fast. Previously I have to use lot of SQL commands to achieve this. Thanks to Data Loader....Ronald


And many more…





Tip
Transfer Data To and From your Desktop to Website Easily!


Articles
Top Tools to Convert MSSQL to MySQL

Step by Step Guide to Migrating MSSQL to MySQL

MS SQL Server and PostgreSQL Datatypes Comparison

How to export data from MSSQL using SQL Server Management Studio

Testing and Validating Databases after Migration

Oracle and MySQL Differences

Most Loved features of MySQL 8

MySQL and MariaDB differences

Convert GUID data from MSSQL to MySQL

PostgreSQL to MySQL Converter

Importing Arabic / Unicode CSV data into MySQL

2 best ways to convert Oracle to MySQL

Data Loader Articles

MSSQL to MySQL migration

MSSQL and MySQL SQL Differences

How to migrate SQL Server to MySQL explained


 

Data Loader now also Converts Views from MSSQL to MySQL, MSSQL to Oracle, Oracle to MySQL, Oracle to MSSQL, MySQL  to MSSQL and MySQL to Oracle

not just data loader also performs views conversion

It lets you convert Views as Views or also lets you Convert Views as Tables. To convert Views as Views please transfer all the tables first and then choose Convert Views option from main screen as shown below

convert views option in main screen

It can convert and directly create views in the target database or it can convert and create a SQL dump file so that you can preview and execute the SQL code yourself

Direct Conversion to Target Database

convert & directly create views in target database

 

Convert Views and Create SQL dump file

convert views and create sql dump file

Data Loader Customers

And as usual Data Loader comes with it's own in built Scheduler. No need to run jobs repeatedly. Just start a Session define the Schedule Date and Time and Data Loader will automatically executes your session in the background and records the actions in a specified log file. You can check the log file to check the result.

The Data Loader uses Repository to Store Sessions. It provides Options to Create a new repository in case the current repository has become damaged or lost, to take backup of existing Repository and to restore repository from a backup location.

You can manage existing sessions through Manage Sessions Form. From here you can the see the Status of existing sessions, Edit, Run,
 Delete or View Log file of individual Sessions.

 

Features:

Convert Data between  MySQL, MS SQL Server,Oracle, Access, Foxpro, CSV

Migrate data between MySQL, Oracle, MS SQL, PostgreSQL, MS Access, FoxPro, Delimited Text Files (Comma Delimited, Tab Delimited, Semi Colon Delimited, any other char Delimited Flat File) to any other MySQL, Oracle, MS SQL, PostgreSQL MS Access, FoxPro, Delimited Text Files (Comma Delimited, Tab Delimited, Semi Colon Delimited or any other Delimited Flat File)

Convert Access to Oracle
Convert Access to MySQL
Convert Access to MS SQL Server
Convert Access to FoxPro
Convert Access To CSV/Text
Convert Access to PostgreSQL

Convert MySQL to Access
Convert MySQL to Oracle
Convert MySQL to MS SQL Server
Convert MySQL to FoxPro
Convert MySQL to CSV/Text
Convert MySQL to PostgreSQL

Convert Oracle to Access
Convert Oracle to MySQL
Convert Oracle to MS SQL Server
Convert Oracle to FoxPro
Convert Oracle to CSV/Text
Convert Oracle to PostgreSQL

Convert MS SQL Server to Access
Convert MS SQL Server to  MySQL
Convert MS SQL Server  to Oracle
Convert MS SQL Server  to Foxpro
Convert MS SQL Server  to CSV/Text
Convert MS SQL Server to PostgreSQL 

Convert FoxPro/Visual FoxPro to Access
Convert FoxPro/Visual FoxPro to MySQL
Convert FoxPro/Visual FoxPro to Oracle
Convert FoxPro/Visual FoxPro to MS SQL Convert FoxPro/Visual FoxPro to CSV/Text
Convert FoxPro/Visual FoxPro to PostgreSQL

Convert CSV/Text to Access
Convert CSV/Text to MySQL
Convert CSV/Text to MS SQL Server
Convert CSV/Text to FoxPro
Convert CSV/Text to Oracle
Convert CSV/Text to PostgreSQL

Convert MS Excel to Access
Convert MS Excel to  MySQL
Convert MS Excel  to Oracle
Convert MS Excel  to FoxPro
Convert MS Excel  to CSV/Text
Convert MS Excel to PostgreSQL

Convert PostgreSQL to Oracle
Convert PostgreSQL to MySQL
Convert PostgreSQL to MS SQL Server
Convert PostgreSQL to FoxPro
Convert PostgreSQL To CSV/Text
Convert PostgreSQL to PostgreSQL

 

Migrate data from your local databases to Cloud databases effortlessly!

migrate on-premises database to cloud

 

Data Loader can be used to upload / sync data from your local MySQL, MS SQL Server, Oracle, Access, FoxPro, CSV to Cloud databases like, MySQL, MS SQL Server, Oracle, Maria DB, hosted in Amazon Web Services RDS or Microsoft Azure without writing a single command.

 

 

Migrate data to amazon aws rds

Migrating MS SQL Server to MySQL hosted on Amazon AWS RDS Cloud step by step guide

Migrating data from local database to Microsoft Azure? Look at this guide for connecting to Azure from Data Loader

 

Create and Generate SQL Dump files

You can use our tool to generate SQL dump files to directly execute in your target database. The generation of SQL dump files are useful where you don't have direct access to the Target Database. 

For Example: Suppose you have a Table in MS SQL Server and this table you want to migrate to MySQL database hosted on another computer. And for some reason you cannot directly access this MySQL database from MS SQL Server. In this scenario you can generate MySQL dump file using Data Loader and then copy and transfer this SQL file to MySQL database server and run this SQL file using MySQL native client utility.

dataloader generates sql dump files

Moreover, Data Loader can automatically generate SQL dump files at your chosen specific interval automatically. You can tell Data Loader whether to overwrite the contents in SQL file or just append the new data into an already existing SQL dump file.

You can create SQL dump files from and to between the following databases

MS SQL Server to MySQL SQL file
MS SQL Server to Oracle SQL file
MS SQL Server to MS SQL Server SQL file

MySQL to MSSQL SQL file
MySQL to Oracle SQL file
MySQL to MySQL SQL file

Oracle to MySQL SQL file
Oracle to MSSQL SQL file
Oracle to Oracle SQL file.

 

Convert data from MS SQL Server Table

mssql table

To MySQL compatible SQL dump file

mysql sql dump file generated from mssql table

 

 

Data Loader Icon

Get Database Loader

For Migrating MySQL, MSSQL, Oracle, Foxpro, Access, CSV

Download Free Trial
No Credit Card Required, No Time limit

Data Loader download

Data Loader Icon

Get Data Loader

For Loading Data into Oracle E-Business Suite thru Forms

Download Free Trial
No Credit Card Required, No Time limit

Data Loader download