Oracle to PostgreSQL Online Presentation

Demo presentation text:


This is the demo about the tools provided by Ispirer Systems for database or scripts migrations. All of them are graphical tools based on a command line tool called Ispirer Migration and Modernization Engine. This demo is particularly devoted to the database conversion from Oracle to PostgreSQL.

For this conversion we will use the following tools:

• Ispirer Migration and Modernization Engine – a command line tool that can be run in batch mode and can perform the automatic conversion of a database or database and application code contained in scripts.

• Ispirer SQLWays Wizard – a GUI tool designed particularly for the database migration. Works with a source database using the ODBC connection.

• Ispirer Migration Studio – a GUI tool oriented specifically to the conversion of a separate application or database script. Works with one script at a time.

• Ispirer Migration Commander – a GUI tool designed for the conversion of multiple files containing application or database code. Works with several scripts at a time.

For this demo, we have prepared 2 databases: an Oracle database and an empty PostgreSQL database where objects from Oracle will be migrated.

Let’s start with Ispirer SQLWays Wizard.

This is a tool that can connect to Oracle database using the ODBC connection only. So, to migrate from Oracle to PostgreSQL you need to provide an ODBC DSN for Oracle on “Choose a source database» page. Also you need to specify a user and a password with the appropriate rights for making selection from system tables of Oracle.

On “Choose a target database” page you need to choose a target database from the list of the supported databases. As you can see, PostgreSQL is specified here. You also need to provide other credentials (like Server, a User and a Password) for the PostgreSQL database for a support of definitions and data load using native utilities of this database.

All the objects that Ispirer SQLWays Wizard manages to extract from the Oracle database are represented in a tree view on “Specify Database Objects” page. Here you can select all the objects required for the migration.

After that, you can specify different options which help you to customize Oracle to PostgreSQL conversion. For example, the option, which controls schema name conversion, reserved words conversion, data types conversion, etc.

On “Specify Export File Options” page, you need to provide a directory, which serves as an intermediate repository for the whole migration process and stores all the automatically generated files, like SQL files with the converted code, text files with the data, BAT or SH files.

The whole process of the migration from Oracle to PostgreSQL is performed in two steps. Each of them has separate logging information.

For the export process, sqlways.log file is provided. It contains the information about the objects read from the source database, their number, the number of rows of data and the number of lines of code per each business logic object. At the end of the export log file there is summary information per each object and summary information for the whole database export.

Similar information but in more readable format is provided in sqlways_report.html file. There is a summary table with the complete export status and statistics per each object type, and there are also tables with the list of objects and more detailed statistics for each object extracted from the source database.

As to the import process, Ispirer SQLWays Wizard generates sqlways_imp.log file that contains information about objects, which were loaded and whether there were any issues during the import process.

Now, let me show you an example of a procedure in Oracle and a converted procedure in the PostgreSQL database.

Let’s call the procedure in Oracle. As you can see, it returned some results. Now I’m going to call the same procedure in PostgreSQL. It contains DML statements, cursor usage, exceptions, raise notice. I’m calling it in PostgreSQL. As you can see, it returned some data, and the data is identical. Therefore, the migrated procedure works correctly!

Now let’s run Ispirer Migration Studio and Ispirer Migration Commander which were designed for database and application scripts conversion purposes.

In Ispirer Migration Studio all you need to do to migrate scripts from Oracle to PostgreSQL is to specify the source and the target of the conversion, paste the source Oracle code to the left panel and run the migration. In the right panel you can see the results of the migration. You can compare the source and target scripts in one tool side-by-side.

Ispirer Migration Commander allows migrating several files or the whole folder at a time. You need to choose the migration direction, specify files for the conversion, and click Run. You also need to provide a target folder, where the converted results will be placed. And click OK.

After the conversion by double-clicking the file in the source and in the target windows, you can review the conversion results side-by-side like in Ispirer Migration Studio.

This is all information about the tools that our company provides for database migration from Oracle to PostgreSQL.

It is just a review of the tools and the features that they support, so if you need additional information please contact us, and we will be glad to assist you in your migration projects.

Thank you very much for your attention. Bye.

Do you want to move from Oracle to PostgreSQL?

Let's do it together!

Learn more