Move Oracle Database to Postgres

Most database professional will easily identify Oracle and Postgres as a very popular database management systems that offers wide arrays of features and tools. Moreover, when you compare these two DBMS, you will realize that Oracle has more strict licensing terms and a high cost of acquiring the software however, the Postgres falls under liberal license that looks very similar to BSD or MIT which is an open source. This points is one of the reasons why a lot of companies would love to move their database from Oracle to Postgres.

The steps below explains why Oracle to Postgres database migration may be considered:

• Export Oracle table definitions in form of data definition language (DDL) statements
• Convert DDL statements into Postgres format including correct type mapping, substitution of Oracle embedded functions that are not supported in Postgres, etc
• Load the converted table creation statements into Postgres database
• Export Oracle data into comma separated values format as intermediate storage
• Transform the data according to Postgres format doing necessary conversion of binary data, dates and escaping special symbols in text if required.
• Import the resulting CSV files into the target database
• Extract Oracle views, packages, stored procedures, functions and triggers in form of the appropriate SQL statements and source code
• Convert all these statements and source code into Postgres format
• Load the result into the target database

The points listed above indicates that it is not easy to convert Oracle database into Postgres format manually. This tedious process takes a lot of efforts and human factor which can cause loss of data or corruption. To automate database migration and avoid the related risk, some specific software is required.

You will find few companies that provides database automation database migration services for Oracle to Postgres. One of this solution is Oracle to Postgres conversion tool created by Intelligent Converters, a software company that has been offering database migration solutions since.

Product Features

1. The following database objects are converted: table definitions, data, constraints, indexes, foreign keys
2. The converter implements direct connection and bulk insert techniques in order to reach high performance of the database conversion process
3. It supports all versions of Oracle and Postgres including “software as a service” (SAAS) variations of these database management systems
4. For purpose of automation Oracle to Postgres converter provides command line support
5. The converter allows to merge and to synchronize existing Postgres database with Oracle data
6. Conversion settings are stored into profile

Aside this features,Oracle to Postgres converter offers awesome and flexible with powerful option as filtering data via SELECT-queries. This feature allows to filter particular columns and records for migration and do wide range of transformations on the data before loading it into Postgres database as follows below.

• Filtering records: SELECT * FROM Orders WHERE StartDate BETWEEN to_date(’15-JAN-16’) AND to_date(’15-FEB-16’)
• Select and rename particular columns: SELECT fname AS FirstName, lname AS LastName, addr as Address FROM People
• Skip NULL values: SELECT * FROM MyTable WHERE Comments IS NOT NULL
• Merge two tables: SELECT T1.code, T1.name, T1.description, T2.image FROM Products T1 INNER JOIN ProductLines T2 ON T1.productline = T2.productline;

As every product of Intelligent Converters, Oracle to Postgres database migration tool is supplied with unlimited support and 1 year subscription for updates.