The data pump utility is a java-based tool that enables you to pump data from one database to another at its current version only. Data can be pumped from the following types of databases:
SQL Server to Oracle
Oracle to SQL Server
Oracle to Oracle
SQL Server to SQL Server
Depending on the operating system, use the appropriate file to run the data pump utility:
For Windows operating systems, use migrate.bat.
For Linux/Unix operating systems, use migrate.sh.
Use the data pump utility to:
only import data into a newly created database
repair damaged databases to only correct issues with regard to database objects (such as constraints, views)
Do not use the data pump utility to:
upgrade from one database version to another
import data into an existing database
correct data-specific issues
correct schema related issues. It is not ideal for large databases (10GB+) due to the performance of the utility. For larger databases, try to manually resolve schema related issues first whenever possible.