Skip to content
Announcing BigAnimal: Fully managed PostgreSQL in the Cloud
Postgres Build 2021: 30 Nov to 1 Dec
Contact usDocsPlans

Solving Compatibility When Migrating your Database from Oracle to Postgres

EDB Team1/30/2020


Back in November last year Gartner launched its State of the Open-Source DBMS Market 2019 report and declared 1: "By 2022, more than 70% of new in-house applications will be developed on an Open Source Database Management System (OSDBMS) or OSDBMS-based Database Platform-as-a-Service (dbPaaS), and 50% of existing proprietary Relational Database Management Systems (RDBMS) instances will have been converted or be in process of converting."  

We believe this indicates open source, and in our case PostgreSQL, is growing rapidly in the enterprise. In December 2019 EnterpriseDB was named in the Gartner Magic Quadrant for Operational Database Management Systems for the seventh year in a row.  We believe our consistent recognition in the Gartner Magic Quadrant underlines our conviction that the benefits of PostgreSQL to enterprise users are becoming clearer across every platform whether on-premise or in the Cloud.

One of the key reasons for the success of PostgreSQL is its compatibility with traditional relational databases, in particular Oracle. This is regularly cited as one of the key benefits of migrating from Oracle as DBAs require less training to complete the task. However, there are compatibility considerations to be aware of, as you prepare to migrate, and our next webinar is dedicated to understanding them in more detail.

Some of our leading PostgreSQL experts, Marc Linster, SVP EDB Product Development, Bruce Momjian, co-founder of the PostgreSQL Global Development Group and Database Architect at EDB and Raghavendra Rao, Managing Consultant EDB Professional Services, will discuss analyzing database objects (DDLs) to find out the incompatibilities between Oracle and PostgreSQL databases, and estimate the time and cost required for a migration.

Marc, Bruce and Raghavendra will discuss schema incompatibility hurdles when migrating from Oracle to Postgres and how to overcome them. The aim is to give you an in-depth understanding of:

  • How you identify if your Oracle schema is compatible with PostgreSQL
  • Incompatibility hurdles and identifying them with migration tools
  • How to overcome incompatibility hurdles 
  • Available tools for conversion
  • Post migration activities - functional testing, performance analysis, data migration and application switchover


The webinar takes place on February 5, 2020 at 10.00am ET | 16.00 CET | 15.00 GMT. Register now.


Gartner does not endorse any vendor, product or service depicted in its research publications, and does not advise technology users to select only those vendors with the highest ratings or other designation. Gartner research publications consist of the opinions of Gartner's research organization and should not be construed as statements of fact. Gartner disclaims all warranties, expressed or implied, with respect to this research, including any warranties of merchantability or fitness for a particular purpose.


1Gartner, Magic Quadrant for Operational Database Management Systems, Merv Adrian | Donald Feinberg | Henry Cook, 25 November 2019.