Data Loader is an easy-to-use tool that will help you import and export data between many common formats.
Current Data Loader supports MS-SQL Server, MySQL, Oracle, MS Access, FoxPro, DBF's, Excel, CSV & Delimited or Flat Files. You can use Data Loader to transfer data from one database format to another database format.
While transferring you can filter columns and specify where conditions. It supports Long , Picture Data types. In a jiffy you can copy data without any coding. Data Loader can also import constraints like primary keys, unique Keys and foreign Keys. Bulk Insert support is also added for MS SQL Server.
Bulk Insert will load data several times faster than conventional insert statements. Data Loader can Synchronize databases by using UPDATE and INSERT feature. Data Loader will Update or Insert rows depending upon whether an existing row exist in the target table.
Now you can load from multiple CSV / Delimited Text files and change destination table names. You can also Save and Schedule Sessions and Data Loader Scheduler will automatically executes sessions at your specified date and time.
Here are some key features of "Data Loader":
· Load from Oracle or MS-SQL Server Views also (Do whatever transformation you want)
· Wizard based
· Saving and Scheduling of Sessions is now possible.
· Fast Speed
· Completely user friendly
· No need to write any code
· Repository Database is introduced.
· MySQL Database support.
· Select single or multiple tables to transfer
· Multiple Tables can be converted into text files simultaneously.
· 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
· Rated Best in the category by many website
· 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
Requirements:
· Microsoft Data Access Components (MDAC Ver. 2.0)
Limitations:
· Can't load more that 50 rows and cannot use "where" to filter rows
· Nag Screen
What's New in This Release: [ read full changelog ]
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.
Find us on Google+
