In the first part of our Oracle migration webinar series, we discussed why developers are leaving Oracle for Postgres and what to think about when planning to migrate.
In Part 2, EDB’s Senior Product Manager Matt Lewandowski and Field Solution Architect Raghav Rao highlight the tools and resources that ease Oracle to Postgres migration. If you missed this webinar, you can watch the on-demand recording here.
Here are our key takeaways:
The biggest migration fear? Migrating data
When we surveyed our customers in 2020 and asked them what they saw as obstacles when migrating from Oracle to Postgres, cost was their smallest concern, followed by migrating the database definitions (15.9% of survey respondents), migrating the stored procedures (22.7%) and moving from proprietary drivers to Postgres open source drivers (22.7%). Their largest concern? Migrating the data (37.9%). EDB is unique because we offer tools that address all of these obstacles.
Oracle compatibility is our secret sauce
Chief among these tools is our database compatibility with Oracle, which provides ample support for those who are concerned about migrating their data.This means an application can run in an Oracle environment as well as in the EDB Postgres Advanced Server edition of Postgres with minimal or no changes to the application code.
EDB Postgres Advanced Server’s compatibility with Oracle is wide and deep. Wide because it covers the gamut of different structures within Oracle and ways of working with Oracle, and deep because it goes far beyond just the surface level. This compatibility covers:
- Data types
- Object types
- Query syntax
- Data dictionary views
- Built-in PL/SQL packages
- Database drivers
- Work-alike DBA tools
What are the benefits of Oracle compatibility?
When you’re doing a migration, you want to do it with the lowest cost and least risk possible. EDB Advanced Server supports your team so they can continue to use their Oracle skills. It also supports your applications so you don’t have to rewrite as much of your applications to make them work with Postgres. This helps to enable:
- An easier transition from Oracle to Postgres for Oracle DBAs and developers, since they can use constructs and even tools they’re already familiar with
- Lowered business costs and reduced risks
- The ability to make the most of the existing skills of your Oracle DBAs and developers
- The ability to leverage existing app infrastructure with native PL/SQL, support and OCI interoperability
- A significant reduction in the amount of time and effort required to migrate
EDB migration tools by your side
Lewandowski touched on our key tools and services designed to help you migrate:
Migration Portal: This free web-based tool assesses the compatibility of Oracle database schemas with EDB Postgres Advanced Server. Simply upload a SQL-formatted data definition language (DDL) file to the Migration Portal, and it analyzes the compatibility of the DDL object, fixes incompatibilities, and reports the results. Watch Lewandowski’s demo in the webinar.
Migration Toolkit: This command line tool offers granular migration control and helps to ease the migration of database objects and data to EDB Postgres Advanced Server or PostgreSQL database. With a rich set of command options, you can control how and which set of source information is loaded into your target database. Request a trial.
Replication Server: This powerful application changes data capture for large migrations with minimal downtime. It replicates between PostgreSQL databases in single-master or multi-master mode and enables you to quickly perform replication between Oracle and Postgres. It offers CLI and GUI options for configuring replication. Request a trial.
Migration Services: Raghav Rao walked us through the importance of having an experienced professional or team that can migrate your database to Postgres.
Why use EDB Professional Services for database migrations to Postgres?
EDB has performed hundreds of migrations, with 15 years of experience in helping customers move from Oracle to Postgres with less impact on their business. We can easily apply workarounds to correct incompatibilities and ensure your system is fully compatible with EDB Postgres. Here are a few of many reasons to work with us:
- Your migration is complex
- You don’t have sufficient resources to perform a migration on your own
- Your team doesn’t have sufficient PostgreSQL expertise
- You need help in assessing, prioritizing and planning migrations for a large number of databases in your organization
What’s needed to support your migrated system?
Like all other legacy systems, Postgres supports monitoring, backups and more. Once your database has been migrated to Postgres, operational tools and processes can help to support:
- Monitoring and management
- Backup and recovery
- High availability
- Security and auditing
- Periodic minor version updates and possible major version upgrades
- Training administrators and users
Up Next: Migration Success Stories
We love hearing about migration gone right. So, that’s the focus of the third and final webinar in our series: Oracle Migration Success Stories. We’ll provide a recap of this webinar soon, so stay tuned!