How to migrate from Oracle to PostgreSQL

PostgreSQL is one the most advanced open source database management systems having strong community of enthusiasts that are continuously improving existing capabilities and add new features.On the other hand, Oracle licensesare very expensive and there is additional cost for extra features. This is the reason why many organizations migrate from Oracle to PostgreSQL despite of the fact the migration takes a lot of time and efforts.

Before beginning the procedure of database migration, it is important to understand which objects, properties and code must be migrated. There is no sense in migrating database objects that are no longer required. For example, decide if any historical data, backup data and temporary table from past maintenanceare required or not.

There areseveraldifferences between Oracle to PostgreSQL that must be subject of special attention during the migration:

The challenges listed above proves that Oracle to PostgreSQL migration is a hard, tedious procedureand the human factor may cause data loss or corruption when running it manually. Database professionals often use special tools to automate database migration and avoid the related risks.

There are few software companies that develop database migration tools for Oracle and PostgreSQL. One of such solutions is Oracle to PostgreSQL by Intelligent Converters, vendor specializing in database migration betweenall popular DBMS such as Oracle, PostgreSQL, MySQL, SQL Server, SQLite, MS Access and IBM DB2 since 2001.

Product Capabilities

Besides basic features listed above Oracle to PostgreSQL converter offers filtering data via SELECT-queries that is powerful capability to pre-process the data before migrating to the target database. Here are few examples of using SELECT-queries for different purposes.

SELECT * FROM People WHERE BirthDate BETWEEN to_date(’1-JAN-80’) AND to_date(’31-DEC-89’)

SELECT fn AS First_Name, ln AS Last_Name, bd as Birth_Date FROM People

SELECT * FROM Docs WHERE Comment IS NOT NULL

SELECT T1.code, T1.name, T1.description, T2.image

FROM Products T1

INNER JOIN ProductLines T2 ON T1.productline = T2.productline;

Exit mobile version