Oracle Data Wizard product tour

Data Pump Wizard is a powerful tool for converting database structure and table data from ADO-compatible sources (i.e. any database for which you have an OLE DB Provider or an ODBC driver, such as MySQL, PostgreSQL, SQLite, Oracle, Firebird, MS Access or MS SQL databases) to Oracle databases.

When running, the wizard guides you through the process of generating SQL script for converting the source database to your Oracle database.

Bear in mind that using templates when working with Data Pump Wizard can be of considerable importance. If you are eager to economize your time and efforts spent for performing customizing operations, using Data Pump Wizard templates is exactly what you need!

Using Data Pump Wizard you also have an ability to save the converted structure and data to a script file. This feature can be useful if there is no need (or no opportunity, e.g. when the target Oracle database is not available at the moment) to convert the structure and table data directly into the database.

To do this, you are to specify the appropriate script file options.

After the script file is created, you can transfer the pumped data to your Oracle database using SQL Maestro for Oracle, for example.