Data Pump for Oracle is a database migration and import tool that enables users to convert database structures and import table data from any ADO-compatible source (such as MS Access or MS SQL Server) into Oracle databases. It provides a wizard-driven interface for configuring connections, selecting objects, customizing the import process, and automating migrations with a command-line utility. The tool supports both structure and data migration, offering options for editing SQL scripts, monitoring the process, and saving configurations as templates for repeated use.

Key Features

User-friendly wizard interface Guided process for configuring and executing migrations.

• Step-by-step setup for connections and object selection.
• Reduces complexity for non-expert users.

Support for ADO-compatible sources Imports data from any local or remote database with an ADO provider.

• Compatible with MS Access, MS SQL, and others.
• Flexible source database support.

Customizable conversion options Selects specific schemas, tables, fields, and indexes for migration.

• Fine-grained control over migrated objects.
• Customize target database structure.

SQL script editing and execution View, edit, and save SQL scripts for generating the target Oracle database.

• Enables manual adjustments before execution.
• Supports script reuse and documentation.

Automated migration via command-line utility Automate and schedule migrations using templates.

• Suitable for batch operations and regular tasks.
• Reduces manual intervention.

Unicode and multilanguage support Handles multilingual and international data.

• Ensures accurate data transfer across languages.
• GUI available in multiple languages.

SSH tunneling and schema specification Secure connections and precise schema targeting.

• Connects to Oracle servers via SSH.
• Allows schema assignment for imported tables.

Template saving for repeatability Saves all migration parameters as reusable templates.

• Facilitates consistent repeated migrations.
• Simplifies setup for similar tasks.

Benefits

Simplifies database migration Streamlines the process of moving data and structures to Oracle.

• Reduces manual steps and potential errors.
• Saves time for database administrators.

Flexible and customizable Adapts to varied migration scenarios and requirements.

• Select only necessary data and structures.
• Edit and preview scripts before execution.

Automation and repeatability Supports unattended and scheduled migrations.

• Enables batch processing for large or recurring tasks.
• Ensures consistency across multiple migrations.

Secure and robust Supports secure connections and handles complex data.

• SSH tunneling for secure data transfer.
• Unicode support for diverse datasets.