Transfer & migrate data with the Data Pump
Want to transfer data from one database to another? Migrate data from an older version to your new database? The Data Pump is the ideal tool to migrate data from one database to another. It works with different database systems for source and destination too, including ADO and ODBC data sources.
- Migrate data from one data source to another
- Can use ADO and ODBC data sources
- Use custom queries to customize data retrieval
- Save a data pump project to use with the command line tool
Easy to use
The Data Pump tool is easy to use. Connect to both source and destination, let the Data Pump automatically figure the order of the destination tables based on foreign key constraints and link source tables to their destination counterparts.
You can automatically map source items to destination items, with a case insensitive fuzzy match of object names.
You can also manually drag and drop tables and columns to link them together.
Detailed progress reporting
There's detailed progress reporting when transferring data, during which you can continu working with the application. After the process has completed, you can view messages and errors by selected each transfer.
Custom SQL queries to transform data
When migrating data from one database to another, it's possible you can't just copy one-on-one.
You can create custom SQL queries to be used as the source for a transfer, the result set columns can be linked to items in the target data soure, just as any table or view can. This allows for powerful data processing when migrating data.
