EMS Data Pump for Oracle

EMS Data Pump for Oracle is an excellent migration tool for converting databases and importing table data from an ADO-compatible source (e.g. MS Access, MS SQL database or any other database with ADO support) to Oracle databases. Easy-to-use wizard application allows you to build the ADO connection string, select tables, fields and indices for converting, view and edit SQL script for generating target Oracle database and fully customize the import process. Data Pump for Oracle has the ability to automate migration to Oracle server task using the helpful console utility. With Data Pump for Oracle database conversion and migration to Oracle become as easy as possible!

Key Features

* User-friendly wizard interface

* Converting structure and data from any local and remote data source having an ADO provider

* Unicode data support

* Selecting source schemas, tables, fields and indexes for conversion

* Fast generation of tables, fields and indexes according to the source database structure

* Easily customizable options for target database objects

* Ability to view/edit, execute and save SQL scripts for generating the target database structure

* Selecting tables and setting criteria for data import

* Full monitoring of the pumping process

* Ability to save all parameters specified within the current wizard session as a template

* Multilanguage GUI support

* Command-line utility to automate the data pump job with the help of a template file

* Ability to connect to the target Oracle server via SSH tunnel

* Ability to specify schema for target database tables