2ndQuadrant | PostgreSQL
Mission Critical Databases
  • Contact us
  • PT
    • EN
    • FR
    • IT
    • ES
    • DE
  • Support & Services
    • Support
      • 24/7 PostgreSQL Support
      • Developer Support
    • DBA Services
      • Remote DBA
      • Database Monitoring
    • Consulting Services
      • Health Check
      • Performance Tuning
      • Database Security Audit
      • PostgreSQL Upgrade
    • Migration Services
      • Migrate to PostgreSQL
      • Migration Assessment
  • Products
    • Postgres BDR
    • PostgreSQL High Availability
    • Kubernetes Operators for BDR & PostgreSQL
    • Managed PostgreSQL in the Cloud
    • Installers
      • Postgres Installer
      • 2UDA
    • pglogical
    • Barman
    • repmgr
    • OmniDB
    • SQL Firewall
    • Postgres-XL
  • Downloads
    • Installers
      • Postgres Installer
      • 2UDA
    • Whitepapers
      • Business Case for PostgreSQL Support
      • Security Best Practices
    • Case Studies
      • Performance Tuning
        • BenchPrep
        • tastyworks
      • Distributed Clusters
        • ClickUp
        • European Space Agency (ESA)
        • Telefónica del Sur
        • Animal Logic
      • Database Administration
        • Agilis Systems
      • Professional Training
        • Met Office
        • London & Partners
      • Database Upgrades
        • Alfred Wegener Institute (AWI)
      • Database Migration
        • International Game Technology (IGT)
        • Healthcare Software Solutions (HSS)
        • Navionics
  • Postgres Learning Center
    • Webinars
      • Upcoming Webinars
      • Webinar Library
    • Whitepapers
      • Business Case for PostgreSQL
      • Security Best Practices
    • Blog
    • Training
      • Course Catalog
    • Case Studies
      • Performance Tuning
        • BenchPrep
        • tastyworks
      • Distributed Clusters
        • ClickUp
        • European Space Agency (ESA)
        • Telefónica del Sur
        • Animal Logic
      • Database Administration
        • Agilis Systems
      • Professional Training
        • Met Office
        • London & Partners
      • Database Upgrades
        • Alfred Wegner Institute (AWI)
      • Database Migration
        • International Game Technology (IGT)
        • Healthcare Software Solutions (HSS)
        • Navionics
    • Books
      • PostgreSQL 11 Administration Cookbook
      • PostgreSQL 10 Administration Cookbook
      • PostgreSQL High Availability Cookbook – 2nd Edition
      • PostgreSQL 9 Administration Cookbook – 3rd Edition
      • PostgreSQL Server Programming Cookbook – 2nd Edition
      • PostgreSQL 9 Cookbook: Chinese Edition
    • Videos
    • Events
    • PostgreSQL
      • PostgreSQL – History
      • Who uses PostgreSQL?
      • PostgreSQL FAQ
      • PostgreSQL VS MySQL
      • The Business Case for PostgreSQL
      • Security Information
      • Documentation
  • About Us
    • About 2ndQuadrant
    • What does “2ndQuadrant” mean?
    • 2ndQuadrant’s Passion for PostgreSQL
    • News
    • Careers
    • Team Profile
  • Blog
  • Menu Menu
Você está aqui: Home1 / Services2 / Migrate from Oracle to PostgreSQL

Migrate from Oracle to PostgreSQL

Break free from vendor lock-in!

Contrary to popular belief, migrating from Oracle to PostgreSQL is only about as expensive as upgrading from one Oracle major version to the next. Both databases are ANSI compliant so lots of stuff just works on either database. For the remainder that doesn’t, we’ve got time-tested solutions which means reduced migration costs.

On this page

  1. Why Migrate to PostgreSQL?
  2. What Will it Take to Migrate?
  3. Tools for Migrating from Oracle to PostgreSQL
  4. PostgreSQL Migration Consultants
  5. Migration Process
  6. What Our Customers Say
  7. Knowledge Base

Why Migrate to PostgreSQL?

Are you sick of footing unbelievably large bills for Oracle licensing and looking for viable alternatives? PostgreSQL is an effective and open source database alternative to Oracle.

Vendor lock-in is undesirable for any organization, and if it pertains to a critical infrastructure component like your database, it can induce a huge financial drain on your business.

PostgreSQL is free forever, with unlimited usage. It is a globally trusted solution that becomes more powerful with every release through community development.

Business Case for PostgreSQL: Learn more about how PostgreSQL can work for your business

Back to top

What will it take to Migrate?

Mitigate risk by evaluating before you migrate. A Migration Assessment is an evaluation of your database prior to initiation of a migration to have an upfront and accurate idea of what will be required. This will ensure a smooth switch without loss of data, unplanned downtime, or unexpected expenses. Learn more

Talk to us today to find out how we can help with an Oracle migration strategy that follows industry best practices. Fill out the form below and someone from our team will reach out to you very soon.

Back to top

Tools for Migrating from Oracle to PostgreSQL

We employ automated migration tools that have been developed in-house to speed up the migration efforts considerably. This ensures an error-free migration of your database to open source PostgreSQL with zero downtime.

PL/Translate – Translate PL/SQL to PL/pgSQL

PL/Translate is an advanced code translator for Oracle PL/SQL to Postgres PL/pgSQL (think ‘Google Translate’ for databases!), which is the missing part of the puzzle for quickly and cheaply migrating from Oracle to PostgreSQL. We believe in ‘code translation’ not ‘code emulation’.

ORQ – Replication from Oracle to PostgreSQL

ORQ implements powerful replication from Oracle to PostgreSQL. Whether you want to set up PostgreSQL as your standby server, or you want to use it as your Analytics database, ORQ implements efficient replication keeping your PostgreSQL instance in sync with your Oracle instance.

Fastloader – COPY from Oracle to PostgreSQL

A PostgreSQL extension containing some Oracle connection functions. It includes an SQL function that allows you to specify all the same options as a COPY statement, as well as connection details to Oracle. Data is streamed back to PostgreSQL using OCI connection, at speeds of up to 2x the speed of the COPY command.

Back to top

PostgreSQL Migration Consultants

Our consultants are the advanced users and developers who developed the tools listed above based on years of experience working to get customers out of their Oracle dilemma. Before they start working on your database, they will provide you with a detailed assessment so you have an idea of the level of effort to expect during the migration process. Anything that can not be automated will be taken care of by these seasoned professionals.

Back to top

Migration Process

The following steps are part of a typical PostgreSQL database migration checklist.

1. Initial Analysis

Before starting, it is critical to analyze the schema, data, and SQL code of the existing database to get an estimate of necessary effort.

2. Migration

Implementation of the tasks determined during analysis, including (but not limited to) schema migration, data migration, SQL migration, Oracle equivalent functions, and application code changes.

3. Testing

All workflows must be thoroughly tested against the newly migrated database. This includes workflows in the application layer as well as within the database. Any issues or bugs can be addressed in testing.

4. Performance Tuning

The new PostgreSQL database(s) need to be tuned to the client environment and usage patterns.

5. Staff Training

Depending on the requirements of the company, 2ndQuadrant experts provide training to your organization’s staff to enable them to handle the new PostgreSQL database.

6. Operations and Continued Support

2ndQuadrant consultants offer ongoing support in the following areas:

  • 24/7 break/fix support. Contributors and advanced PostgreSQL users are available 24 hours a day, 7 days a week, 365 days a year to ensure fast resolution of any issue that might arise.
  • Backup & Recovery. Backup and recovery planning for disaster mitigation and Point in Time Recovery (PITR) using popular tools like Barman.
  • Replication setup. Simplified management of replication, failover, and switchover for your database(s).
  • High availability. Highly Available Single Master and Multi-Master Replication architectures for enterprise-grade database clusters.
Back to top

What Our Customers Say

 
123

“It is now the expectation to select Postgres over Oracle for a range of use-cases, with Postgres becoming our preferred technology choice.”

James Tomkins, Data Services Portfolio Technical Lead, Met Office

“With consulting performed by 2ndQuadrant, Navionics welcomed a migration to PostgreSQL, drastically lowering the cost of our database management and software licensing.”

Laura Passigni, Project Manager, Navionics

“2ndQuadrant was initially recommended as a to-go company to get quality consulting for PostgreSQL. We are happy with that recommendation.”

Nickolay Schwarz, CTO, BenchPrep

Back to top

Knowledge Base

Case Studies

Global Online Gaming Provider Migrates Tightly Regulated Database to PostgreSQL

Global gaming company, IGT, migrated to PostgreSQL to deliver entertaining and responsible gaming experiences for players across all channels and regulated segments. IGT was seeking a more cost-efficient solution for their globally distributed database that was running on a popular, yet expensive, DBMS. In addition to reducing costs, they wanted to minimize OLTP workloads. IGT chose to migrate their database to the cost-effective and feature-rich PostgreSQL. Find out how 2ndQuadrant helped IGT successfully migrate to PostgreSQL and have reported zero outages in the last year since the switch.

Download Case Study

Healthcare Software Company Migrates High Workload Database to PostgreSQL

Leading provider of RIS (Radiology Information Systems) to public healthcare organizations – Healthcare Software Systems (HSS) – chose to migrate their patient record database from Oracle to PostgreSQL. The HSS database manages the provision of critical systems to public healthcare organizations, health trusts, hospitals and clinics. The critical nature of the patient record system could not be jeopardized in any way – whether that be loss of access or reduced performance – and HSS leaned on the expertise of 2ndQuadrant to ensure a successful transition with ongoing support. Learn more about the Healthcare Software Systems’ migration experience with 2ndQuadrant’s world class experts.

Download Case Study

Electronic Cartography Company Migrates to PostgreSQL and Implements Barman for Backup & Disaster Recovery

Navionics identified PostgreSQL as a highly scalable system with a backup and recovery strategy for its mission-critical environment. Navionics has the world’s largest database of marine and lake charts, covering the salt waters of the entire planet. 2ndQuadrant and its team of world-class experts helped Navionics during the migration process and implemented a proactive failure-proof backup and recovery strategy.

Download Case Study

Videos

Webinar: Migration to PostgreSQL by Gianni Ciolli

In this session, Migration to PostgreSQL was discussed and how it can be a tricky decision as it requires planning, testing, knowledge to handle challenges, and much more. 

Watch Video

Blogs

Nothing Found

Sorry, no posts matched your criteria

View All Blogs
Back to top
Back to Postgres Support & Services

.

Get in touch with us!

Please fill in the form below and we'll be in touch as soon as possible.

© 2ndQuadrant Ltd. All rights reserved. | Privacy Policy
  • Twitter
  • LinkedIn
  • Facebook
  • Youtube
  • Mail
Scroll to top
×