Data Loader


Data Loader Ver.4.5 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


A tool to automate filling of Forms. Specially built for Oracle Apps 11i / R12. Load hundreds of rows through Macros or Forms Record and Playback in Oracle EBS Forms in minutes

Download Buy More Info

 


Data Loader is a simple yet powerful tool to export and import Data between many common database formats. Current Data Loader Ver.4.5 supports MySQL, Oracle, MS Access, Excel, FoxPro, DBF, MS SQL Server, CSV and Delimited or Flat Files. You can use Data Loader to convert data from one database format to another database format. While transferring you can filter columns and specify WHERE conditions. Supports full mapping of source columns to target table columns.

 New Version 4.5 Released (Download Free Trial Version Now)

The Most Popular Data Migration Tool available on the internet.

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

  • Load data into any existing target table 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 executables

  • Supports repository to easily manage all existing sessions

  • Comes with its own scheduler or you can use Windows Task Scheduler

  • Support Bulk Inserts feature load millions of rows faster

 New Features in Version 4.5

  • 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 schedule to execute at specified intervals
  • No need to of MySQL ODBC driver, now Data Loader uses MySQL Library
  • Improved Data type matching
  • Many enhancements have been made and bugs fixed.

New Features in Version 4.1

  • 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

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.

 New Features in Version 4.0

  • 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.

    Note: Please make sure that you have a Primary Key and Index defined on the matching columns in Target table. Otherwise the loading will progress slowly when UPSERT or INSERT option is selected

    For visual explanation of UPSERT and INSERT loading option please click here

 

 New Features in Version 3.6.1

  • Excel support has been added. Now you can convert data from Excel worksheet to any of the supported databases.

  New Features in Version 3.6

  • Full Editing feature added. Now you can edit, delete column mapping of saved sessions.

  New Features in Version 3.5

  • Now you can create SQL Dump files from any Source Database.
  • SQL dump files are useful if you have to load the data into MySQL Server, Oracle or MS SQL Server
    where you don't have a direct connection.

  New Features in Version 3.0

  • Folder polling.

Data Loader will watch for files in a folder at specified intervals and then load the data from filenames
matching specified pattern into tables automatically.  More...

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

  New Features added in Version 2.5

  • Load data in MySQL databases hosted on Share Web Hosting easily
  • Now you can change and choose the destination tables 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 through the help of views

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:

  • Load from Oracle or MS-SQL Server Views also (Do whatever transformation you want)Convert Data from Access to MySQL
  • Wizard based
  • Saving and Scheduling of Sessions is now possible.Convert Data from MySQL to Access
  • Fast Speed
  • Completely user friendly
  • No need to write any code
  • Repository Database is introduced. Convert Data from Access to MS SQL Server
  • MySQL Database support. Convert Data from Access to Oracle
  • Select single or multiple tables to transfer
  • Multiple Tables can be converted into text files simultaneously. Convert Data from Foxpro to Oracle
  • Select or Deselect Columns while transferring
  • Change Destination Data types and widths
  • Automatic Checking of Data type mismatch
  • Specify WHERE condition to filter data
  • Filter Columns and Specify Where Conditions while converting from database to Text  Convert Data from MS SQL Server to Oracle
  • Rated Best in the category by many website
  • Most Popular product in Database App. section in download.com
  • Economical costs just $99 For Standard Version
  • Trial version available
  • Transfer Millions of rows easily and fast. That's what our existing Customers are doing
  • Supports Long , Picture Data types. In a jiffy you can copy data without any coding
  • Supported O/s: Win 2003,Win 2000, XP, Win ME,Win98 & Win95

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

Migrate between MySQL, Oracle, MS SQL, 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, MS Access, Foxpro, Delimited Text Files (Comma Delimited, Tab Delimited, Semi Colon Delimited or any other Delimited Flat File)

 

 

Use Data Loader to  

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

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

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

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 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 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 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

   

(Download Free Trial Version Now)

  Watch Data Loader in action. View Data Loader demo video showing an example of migrating data from MySQL to MS SQL Server

MySQL partner

Latest News
01/02/2013
Data Loader Ver. 4.5 released
27/03/2012
Data Loader Ver. 4.1.2 Released
21/03/2011
Data Loader Ver. 4.1. Released
11/10/2010
Data Loader Ver. 4.0 Released
04/12/2009
Data Loader Ver. 3.6.1 released
03/08/2009
Data Loader Ver. 3.6 released
17/04/2009
Data Loader Ver. 3.5 released
17/04/2008
Data Loader Ver. 3.0 released
05/01/2007:
Data Loader 2.5 is released
10/11/2006::.
Data Loader v2.0 is released.
08/09/2006::.
Got Popular rating at download.com
21/11/2005::.
Got 5 star rating at tucows.com
12/07/2005::.
Got 5 star rating at download.com
08/06/2005::.
Data Loader v1.0 is released.
10/07/2005::.
Got top ratings at ...almost everywhere.

 

Our Esteem Customers
* 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…

 

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

Data Loader 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!