Downloaded 15 times
Uploaded byAshnikbiz
Migration from Oracle to PostgreSQL: NEED vs REALITY
The webinar discusses the migration from Oracle to PostgreSQL, emphasizing PostgreSQL as a viable alternative to traditional commercial databases. Key topics include the features of EnterpriseDB Postgres, migration challenges, and best practices, as well as a demo on planning and executing the migration. Use cases highlight the benefits and risks associated with migration, along with operational support and training offered by EnterpriseDB.
In this document
Powered by AI
Introduction to the webinar and the need for migration from Oracle to PostgreSQL. Key benefits of PostgreSQL and features of EnterpriseDB.
Discussion on the growth of open source databases compared to traditional options. PostgreSQL as a competitive alternative.
Overview of EnterpriseDB Postgres as a robust alternative to Oracle, highlighting the tools and Migration Portal available.
Insights on migration approaches, including planning, risk factors, and the use of the Migration Portal for assessments. Details on the Migration Portal and schema assessment. Includes customer case studies in telecom and government sectors.
Overview of operational support and training options provided post-migration to ensure DBA readiness and continuous support.
Closing remarks thanking the participants for attending the webinar.
More Related Content
![[EPPG] Oracle to PostgreSQL, Challenges to Opportunity](https://cdn.slidesharecdn.com/ss_thumbnails/eppg-oracletopostgresqlchallengestoopportunity-190409033058-thumbnail.jpg?width=600ounds&width=560&fit=bounds)
![[pgday.Seoul 2022] 서비스개편시 PostgreSQL 도입기 - 진소린 & 김태정](https://cdn.slidesharecdn.com/ss_thumbnails/postgresql-221121085744-f0fb1a8a-thumbnail.jpg?width=600ounds&width=560&fit=bounds)
Similar to Migration from Oracle to PostgreSQL: NEED vs REALITY
Migration from Oracle to PostgreSQL: NEED vs REALITY
- 1. LIVE WEBINAR: Migration fromOracle to PostgreSQL: NEED vs REALITY
- 2. Sandeep K. CTO &Director, Ashnik Jayaraj S. Solution Architect, EnterpriseDB Sushant P. Database Solution Consultant, Ashnik Nishchay K. Database Consultant, Ashnik
- 3. Webinar Covers • PostgreSQLas a solid alternative Enterprise Database • EnterpriseDB Postgres features, range of tools and Migration Portal • Challenges and best practices before and after migration • Demo - How to plan and migrate from Oracle to EnterpriseDB Postgres – see it to believe
- 4. Open Source Database- a Game Changing Trend Cloud and open source databases are growing even faster than the industry average.
- 5. PostgreSQL, a strongalternative to traditional commercial Databases Capability to innovate rapidly to deliver new functionality, greater agility and reduce overall TCO.
- 6. EnterpriseDB Postgres -an enterprise open source Database alternative to ‘Oracle’ Containment - New workloads - Migration
- 7. Let’s deep diveinto the EnterpriseDB Platform A Feature Rich Platform – which offers offer a range of tools, and the EDB Postgres Migration Portal
- 8.
- 9. We will cover: •Migration Planning • Risk Factors • Migration Portal • Customer Use Cases • Operational Support
- 10. Plan the migrationin advance Planning and Identification
- 11.
- 12. What are therisks? Assessment and Feasibility
- 13. What applications tostart with? Good to Start with Avoid • Developed using open standards • Open standard connections • Not much dependent on server side code – stored procedures etc • Vendor already supports Postgres or EDB Postgres • No RAC scalability requirement • No need of flashback • Uses proprietary connection method e.g. tnsnames • Multiple DBlink dependencies or dependents • Has dependencies on other applications/databases
- 14. Migration Portal Assessment andEffort estimation
- 15. Migration Assessment usingMigration Portal • How easy will it be to perform the migration? • What are the risks? • Will all my server side code (Stored procedures) work fine? • Is my application compatible? • How much testing effort will be needed?
- 16.
- 17.
- 18.
- 19. Customer Use Cases Challengesand success stories
- 20. Telecom case study: Schema migration • Application Platform and drivers : Java (JDBC) • Reason for Migration : 1. Operational cost reduction 2. Oracle License Cost • Challenges : 1. Interval Partitions 2. Views 3. DB links 85% Compatibility with EDB Postgres advance Server Oracle Compatibility features of EDB Postgres Advance Server 60% schema Compatible with PostgreSQL
- 21. Government Use Case: Schema Migration • Application Platform and drivers : application on Java (JDBC) • Reason for Migration : 1. Oracle License Cost 2. Microservices • Challenges : 1. Oracle RAC 2. Schema with more than 700 objects and Approx. 3TB size schema for migration 3. Oracle security features 4. Oracle unlogged tables
- 22. Day 2 OperationalSupport Make your DBA ready
- 23. Training and operationalsupport • Training provided by certified trainer • Periodic health checks • Managed DBA service • On-call remote DBA pack • Solution Architecture – extension to your Enterprise Architecture Team • 24*7 SLA based support from EnterpriseDB
- 24.