Solving Compatibility When Migrating your Database from Oracle to Postgres

Back in November last year Gartner launched its State of the Open-Source DBMS Market 2019 report and declared ¹: "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 Postgres, 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 Postgres 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 Postgres 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.

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

Marc, Bruce and Raghavendra discussed 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 Postgres
• 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

View the Oracle to Postgres Schema Migration Hustle webinar here.

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.

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