Downloaded 29 times
Uploaded byEDB
No Time to Waste: Migrate from Oracle to EDB Postgres in Minutes
The document discusses the benefits and components of migrating from Oracle to EDB Postgres, highlighting EDB's status as a leader in open-source database solutions and the various tools available for facilitating migration. It emphasizes the importance of selecting the right target, considering schema, data, and code during the migration process, and the need for proper tools for successful operational integration. The document also outlines next steps for training and utilizing EDB's offerings.
No Time to Waste: Migrate from Oracle to EDB Postgres in Minutes
- 1. CONFIDENTIAL © CopyrightEnterpriseDB Corporation, 2020. All rights reserved. 1 Migrate from Oracle to EDB Postgres In Minutes Prashant Agarwal - SDM Product Development EnterpriseDB
- 2. CONFIDENTIAL © CopyrightEnterpriseDB Corporation, 2020. All rights reserved. • EDB Overview Why migrate? Components of a successful migration project Pick your battles What does EDB bring to the table? Demo Next steps AGENDA 2
- 3. CONFIDENTIAL © CopyrightEnterpriseDB Corporation, 2020. All rights reserved. WHO IS EDB? • Founded in 2004 • Recognised RDBMS leader by: • Gartner • Forrester • Customer base > 4000 3 A global leader in open-source based Postgres software and services
- 4. CONFIDENTIAL © CopyrightEnterpriseDB Corporation, 2020. All rights reserved. EDB Recognised for 7 Years In A Row on Gartner’s Magic Quadrant 4 ONLY OPEN SOURCE BASED RDBMS IN GARTNER MQ
- 5. CONFIDENTIAL © CopyrightEnterpriseDB Corporation, 2020. All rights reserved.5 • Have you used EDB Migration Portal earlier? • Yes • No Poll Question
- 6. CONFIDENTIAL © CopyrightEnterpriseDB Corporation, 2020. All rights reserved. WHY MIGRATE? • Total Cost of Ownership (TCO) • Leverage Innovation • Outgrowing system need • Software vendors withdraw their support (EOL) • Strategic decision to use a specific DBMS 6
- 7. CONFIDENTIAL © CopyrightEnterpriseDB Corporation, 2020. All rights reserved.7 ECONOMIC REASONS Source: IDC: The Economic and Business Advantages of EnterpriseDB Postgres Database Solutions, 2016
- 8. CONFIDENTIAL © CopyrightEnterpriseDB Corporation, 2020. All rights reserved.8 INNOVATION LEADER • Vibrant community • ACID Compliant • SQL + JSONB + KVP + GIS • Many data types • Foreign data wrappers • Native streaming and logical replication • …
- 9. CONFIDENTIAL © CopyrightEnterpriseDB Corporation, 2020. All rights reserved.9 EDB COMPATIBILITY WITH ORACLE SCHEMA DATA CODE MOST OF THE WAY SCHEMA, DATA, AND CODE PART OF THE WAY SCHEMA AND DATA ONLY INTERFACE All OF THE WAY SCHEMA, DATA, CODE, AND INTERFACE
- 10. CONFIDENTIAL © CopyrightEnterpriseDB Corporation, 2020. All rights reserved.10 PICK YOUR BATTLES ~50% migrations are easy … ~30% involve more work … ~20% are difficult 51% had slight to no modifications
- 11. CONFIDENTIAL © CopyrightEnterpriseDB Corporation, 2020. All rights reserved.11 EDB POSTGRES MAKES IT EASY • EDB Advanced Server: • Oracle compatible Postgres • EDB Cloud Database Service: • Run Oracle compatible Postgres in the the cloud • Migration tools: • EDB Migration Portal: Cloud-based migration for schemas and stored procedures • EDB Migration Toolkit: One-time data migration • EDB Replication Server: Change data capture for large migrations with minimal downtime • Application drivers: OCL, JDBC, ODBC, .NET, ECPG*Plus • Management Tools • EDB Postgres Enterprise Manager • EDB Failover Manager
- 12. CONFIDENTIAL © CopyrightEnterpriseDB Corporation, 2020. All rights reserved.12 Toad for Oracle Toad Edge for EDB Postgres (1) Download DDL Extractor (2) Run DDL Extractor (3) Upload Oracle schema definition (4) Analyse schema (5) Download converted schema (6) Create schema (7) Migrate the data using EDB MTK USING EDB MIGRATION PORTAL
- 13. CONFIDENTIAL © CopyrightEnterpriseDB Corporation, 2020. All rights reserved. DEMO 13
- 14. CONFIDENTIAL © CopyrightEnterpriseDB Corporation, 2020. All rights reserved. Summary And Lesson Learned Migration is not hard • Pick the right target • Schema and data are only the first steps • Code and drivers are important • Tools are essential for operational integration 14
- 15. CONFIDENTIAL © CopyrightEnterpriseDB Corporation, 2020. All rights reserved.15 • Which database are you looking up for migration? • Oracle • SQLServer • MySQL • DB2 • Other Poll Question
- 16. CONFIDENTIAL © CopyrightEnterpriseDB Corporation, 2020. All rights reserved. NEXT STEPS • Sign up for free training: https://www.enterprisedb.com/free- postgres-training • Download EDB Postgres Advanced Server (60 day trial) https://www.enterprisedb.com/software-downloads-postgres • Try the EDB Migration Portal https://migration.enterprisedb.com • Get in touch info@enterprisedb.com 16
- 17. CONFIDENTIAL © CopyrightEnterpriseDB Corporation, 2020. All rights reserved. QUESTIONS & DISCUSSION 17
- 18. THANK YOU info@enterprisedb.com www.enterprisedb.com CONFIDENTIAL ©Copyright EnterpriseDB Corporation, 2020. All rights reserved.