Download to read offline
Uploaded byDatavail
Is Application Refactoring Holding Back Oracle to PostgreSQL Migrations? – Presented by Datavail
Is Application Refactoring Holding Back Oracle to PostgreSQL Migrations? | Presented by Datavail Migrating from Oracle to PostgreSQL is a strategic move for many organizations seeking to reduce costs, escape vendor lock-in, and embrace open-source innovation. However, while data migration is often straightforward, application refactoring remains a major barrier. In this presentation, Datavail and Liberatii explore how Intelligent Database Virtualization can eliminate the need for extensive code rewrites, enabling faster, safer, and more cost-effective migrations. Featuring insights from Eric Russo (Datavail), Dr. James Reynolds, and Nima Torabi (Liberatii), this session highlights real-world challenges and solutions for modernizing legacy Oracle environments. 🔗 View the full presentation here: https://www.datavail.com/resources/is-application-refactoring-holding-back-oracle-postgresql-migrations/ 🔍 Key Highlights Why PostgreSQL?: Growing popularity among developers, cloud-native support, and open-source flexibility. Challenges with Oracle: High licensing costs, complex agreements, vendor lock-in, and slow innovation. The Real Bottleneck: Application migration—not data migration—is the biggest hurdle. Datavail’s Experience: Lessons learned from helping clients migrate complex Oracle environments. Liberatii’s Solution: A no-code virtualization platform that enables Oracle apps to run on cloud databases like PostgreSQL, MySQL, and SQL Server. Migration Benefits: 10x faster migration timelines Up to 90% reduction in risk Near-zero downtime Seamless cloud deployment on AWS or Azure Security & Performance: Zero-trust architecture, end-to-end encryption, and sub-3ms latency for OLTP workloads. Advanced Features: Query translation, error mapping, schema conversion, and CDC-based replication. 🎯 Why Watch This Session? This presentation is ideal for: IT leaders planning Oracle-to-PostgreSQL migrations Cloud architects and DBAs seeking modernization strategies Organizations facing application refactoring challenges Teams evaluating AWS MAP or Microsoft funding programs for migration
Is Application Refactoring Holding Back Oracle to PostgreSQL Migrations? – Presented by Datavail
- 1. Is Application Refactoring Holding BackYour Oracle to PostgreSQL Migrations? Datavail Introduces Intelligent Database Virtualization from Liberatii PGConf NYC
- 2. www.datavail.com 2 Speaker Introductions EricRusso SVP – Database Services Datavail Dr. James Reynolds Chief Software Architect Liberatii Nima Torabi CEO & Co-founder Liberatii
- 3. What the industryis saying • Popularity skyrocketing but because of licensing costs, market share/spend reported by Gartner and other research firms is still in Oracle/Microsoft SQL. • For those companies wanting to move off of especially Oracle, PostgreSQL is #1 choice – especially among developers. • AWS and Azure making it easier to move to their clouds. • New projects – PostgreSQL #1 database of choice. • PostgreSQL Database of the Year in 2023. The Flight From Oracle to PostgreSQL
- 4. www.datavail.com 4 Challenges withOracle Databases Cost Burden: High licensing and maintenance fees strain IT budgets. Complex Licensing: Restrictive licensing agreements hinder optimal utilization. Vendor Lock-in: Heavy reliance on Oracle-specific makes migration daunting. Rigidity and slow innovation: Legacy systems can impede the adoption of newer, more efficient technologies.
- 5. www.datavail.com 5 Data Migration AppMigration The Real Challenge Is App Migration, Not Data Migration.
- 7. I’ll rewrite mySQL Use AI! Click! Datatypes User testing Performance Lifecycle Packages Middleware Error codes DB Links
- 8. www.datavail.com 8 Conventional OracleDatabase Migration and Its Inherent Challenges Rewriting millions of lines of code Spending millions of dollars Spending 1-3 years 83% Failure rate
- 9. www.datavail.com 9 Datavail’s ExperiencesHelping Clients Migrate Migrations can be complex and span over multiple months Data types and schema conversion have gotchas • Issues with converting defined data types • Complex Oracle packages cannot be converted to PostgreSQL easily Application Challenges • Seen situations where continued development on the legacy application delayed the cut over month after month – some businesses have to keep adding functionality Minimizing down time and the cutover
- 10. Datavail’s Search fora Better Way… Brought Us to Liberatii Datavail has managed and migrated database environments for clients since 2007. From start-ups to enterprises, Datavail managed hundreds of thousands of databases for 400 clients. Intense interest especially in moving from Oracle to PostgreSQL – but challenges abound. RDBMS continue to be dominant players, however, NoSQL and Open Source systems are growing dramatically – especially with the move to cloud-based environments. Our search for a better way brought us to Liberatii’s database virtualization platform.
- 11.
- 12. www.datavail.com 12 Liberatii makesOracle apps work with cloud databases No Code required Applications on Oracle Liberatii Data Platform Cloud Databases
- 13. www.datavail.com 13 No moreOracle lock-in 10X Faster Up to 90% Near-Zero Risk Database migration in weeks not years Reduction in database TCO Seamless migration by keeping the app
- 14. www.datavail.com 14 Migrate tocloud at maximum velocity with optimum TCO Lift and shift legacy apps on Oracle to the cloud Re-platform to cloud managed databases using Liberatii (Break free from Oracle databases) Modernise apps with purpose-built Liberatii Data Platform at your own pace
- 15. www.datavail.com 15 Deploy Liberatiiin Azure or AWS within minutes Connect Liberatii to the Source and Target database Migrate the schema and data with Liberatii Configure the application to point to Liberatii
- 16. www.datavail.com 16 Design Principles Nocode change No compromise on performance 100% Application correctness
- 17. www.datavail.com 17 Oracle (10g,11g, 12c, 18c, 19c, 21c) SQL Server (10 to 15) PostgreSQL PostgreSQL (community edition) MySQL (community edition) Amazon Aurora Azure Database for PostgreSQL/MySQL Azure SQL SQL Server (Managed Instance) SQL Server on Azure Virtual Machines NoSQL (MongoDB) Database Support Source Databases Target Databases
- 18. www.datavail.com 18 Liberatii DataPlatform Features Very Low Latency High Availability (99.99%) High Scalability Secure Connection Near-Zero Database Downtime Application Agnostic (2-3 Milliseconds for OLTP) Across multiple regions Up to 1000 Instances Support for TLS protocol across all connections Supercharge replication with Change Data Capture (CDC) Provides connectors for OCI, JDBC, ODBC And Pro* C
- 19. www.datavail.com 19 Liberatii’s purposefullybuilt for risk-averse organisations Secure Data: Liberatii is deployed in your Azure tenant. Your data stays in your tenant, never exposed to the public internet. End-to-End Encryption: Liberatii encrypts data in motion and in transit. Zero-Trust Architecture: Trust No One, Secure Everything: zero trust architecture for impeccable in-tenant security. Open-Security Platform: Customize your security with Our flexible security integration options (add your extra security features to our platform).
- 20. www.datavail.com 20 Oracle-Specific syntaxexamples Join (+) operator Collections/Records/Objects Synonyms SELECT * FROM A, B WHERE A.id = B.id(+); SELECT * FROM A LEFT JOIN B ON A.id = B.id; TYPE my_record IS RECORD ( field1 VARCHAR2(100), field2 NUMBER); CREATE TYPE my_record AS ( field1 TEXT, field2 INTEGER); CREATE SYNONYM my_synonym FOR schema.object; CREATE VIEW my_synonym AS SELECT * FROM schema.object;
- 21. www.datavail.com 21 Oracle-Specific syntaxexamples Nested functions Packages... Autonomous Transactions... DECLARE FUNCTION f1(p2 NUMBER) RETURN VARCHAR2 AS BEGIN RETURN p2; END; BEGIN DBMS_OUTPUT.PUT_LINE(f1(3)); DBMS_OUTPUT.PUT_LINE(f1(10)); END; CREATE OR REPLACE FUNCTION anonf1v0 (p2 NUMERIC) RETURNS TEXT AS $$ BEGIN RETURN p2::TEXT; END; $$ LANGUAGE pgsql; DO $$ BEGIN ...
- 22. www.datavail.com 22 Advanced QueryTranslation Features Query Optimisation Query Translation Cache Error Message Mapping Override Query Translation
- 23. www.datavail.com 23 Oracle: Standard F8sv2 (8 vcpus, 16 GiB memory) Gateway: Standard D4s v3 (4 vcpus, 16 GiB memory Postgres: Standard F8s v2 (8 vcpus, 16 GiB memory) Transaction Performance (TPC-C) Benchmarks
- 24.
- 25.
- 26. www.datavail.com 26 Timeline: • 4to 8 weeks for medium-complexity migration projects • 6 to 10 weeks for highly-complex migration projects Required Staff Resources: • One Application Developer: Replicate the application in the sandbox environment, change application connectivity driver, run the tests and replay existing workloads for performance • Client side resource allocation - approx 10~12hrs weekly • One Database Administrator (Oracle DBA): Provision a new Oracle database in the sandbox environment, migrate data and collect database traces and logs • Client side resource allocation - approx 10~12hrs weekly Project Outlook
- 27. www.datavail.com 27 Migration Process Assessment Plan& Build Schema Conversion Data Transfer Cut Over Test
- 28.
- 29. www.datavail.com 29 Liberate YourEnterprise From Oracle Move off Oracle in weeks, not years Keep existing Oracle apps, run natively on cloud databases Overcome vendor lock-in and reduce total cost of ownership
- 30. www.datavail.com 30 Plan yourmigration – white board session Analyze options for funding from Datavail and Liberatii partners - AWS and Microsoft For instance - AWS MAP Funding Program • MAP Methodology has three phases: 1. Assessment Phase 2. Mobilize Phase 3. Migrate or Modernize Datavail can leverage MAP Partner Cash Funding in the Assess and Mobilize phases to support customers in building strong AWS cloud foundations, accelerate and reduce risk, and offset the initial cost of migrations. MAP also offers AWS Promotional Credits (MAP Credits) to customers in the Migrate & Modernize phase. How We Can Help
- 31.
- 32.