Data Loader is a simple software tool to export and import data between many common database formats supporting 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. While transferring, you can filter columns and specify conditions.
Data Loader supports full mapping of source columns to target table columns. It also supports constraints and indexes and exports and imports primary, unique and foreign keys, not null and default values which are bulk inserts for Microsoft SQL Server databases.
This method greatly improves performance so you can load millions of rows in a small amount of time. Data Loader migrates between MySQL, Oracle, MS SQL, MS Access, Foxpro, delimited text files (comma, tab, semi colon delimited or any other char delimited flat file) to any other MySQL, Oracle, MS SQL, MS Access, Foxpro, delimited text files (comma, tab, semi colon delimited or any other delimited flat file).