Slide 1

Slide 1 text

Migrate from Oracle to PostgreSQL with Azure Azure webinar series

Slide 2

Slide 2 text

How do I ask a question? If you have a technical or content-related question, please use the Q&A window We will address the questions as they come in Can I view this presentation after the webinar? Yes, this presentation is being recorded A link to the recorded presentation will be sent to the email address you used to register Welcome

Slide 3

Slide 3 text

Meet our speaker Saurabh Modi Principal PM Sai Krishna Srirampur Sr. Software Engineer

Slide 4

Slide 4 text

Webinar Learning Objectives • Introduction to Postgres and benefits of Azure Database for PostgreSQL. • Learn why customers are selecting Postgres to modernize Oracle workloads. • Demo, migrating Oracle to Azure Database for PostgreSQL. Learn what a typical migration path can look like. At the end of the session, you should be better able to…

Slide 5

Slide 5 text

About Postgres

Slide 6

Slide 6 text

PostgreSQL is more popular than ever loved wanted https://insights.stackoverflow.com/survey/2019?utm_source=so-owned&utm_medium=blog&utm_campaign=dev-survey-2019&utm_content=launch-blog https://db-engines.com/en/blog_post/76 https://db-engines.com/en/ranking_trend/system/PostgreSQL DBMS of the Year DB-Engines’ ranking of PostgreSQL popularity

Slide 7

Slide 7 text

PostgreSQL is more popular than ever Why PostgreSQL? Open source Proven resilience & stability enterprise- ready • Extensible and tooling Rich feature set • Rich indexing and data types, including geospatial

Slide 8

Slide 8 text

Extensions

Slide 9

Slide 9 text

© 2019 Microsoft Corporation Azure V.1 – Q3 FY20 With Azure, PhD not required Fully managed OSS community databases on MySQL, PostgreSQL, MariaDB Integrates Azure services with streamlined provisioning and management experience for common OSS frameworks and languages Secure and compliant with Advanced Threat Protection and Azure IP Advantage Best total cost of ownership with built in HA with 99.99% SLA Enterprise-ready Easy migration Developer productivity Built-in intelligence optimizes performance and security Enterprise scale with Hyperscale Scale PostgreSQL databases across 100s of nodes with Hyperscale

Slide 10

Slide 10 text

Migrations

Slide 11

Slide 11 text

Reasons to migrate Oracle to Azure PostgreSQL Migrate Oracle PL/SQL stored procedures, queries, datatypes, packages, sequences etc. to PostgreSQL with little or no code changes Although incompatibilities exist, experts say migrating from Oracle to PostgreSQL is no costlier than upgrading from one major version of Oracle to the next major version of Oracle Oracle Azure POSTGRESQL PL/PGSQL IS HIGHLY COMPATIBLE WITH ORACLE PL/SQL LOWERING MIGRATION COST AND RISK

Slide 12

Slide 12 text

M A N A G E D C O M M U N I T Y V E R S I O N Focus on your apps by leaving the management and patching of your infrastructure and database to an enterprise-ready cloud service with: • Automatic updates • Automatic security fixes • Automatic new feature updates PostgreSQL: 9.5, 9.6, 10, and 11 Reasons to migrate Oracle to Azure PostgreSQL

Slide 13

Slide 13 text

Oracle to PostgreSQL | Cost of Ownership Customers migrate from Oracle to Azure database for PostgreSQL to reduce overall cost of ownership by up to 95% in savings* Configuration is based on a 4 socket, 32 core x86 possessor Oracle Cloud Service editions are based on virtual machines • *Oracle licensing for Enterprise Edition is based on number of processors which is derived by multiplying the number of cores by a factor. In the case of this example it is 32 cores multiplied by .5 for x86 resulting in 16 processors. • **Annual maintenance and support for Oracle is 22% of the annual license cost. • ***Oracle standard terms for Enterprise Edition is 50% of list pricing for 3 years. This example accounts for the 50% list pricing for 3 years in the total. Oracle Database Cloud Service Enterprise Edition Oracle Database Cloud Service Enterprise Edition High Performance Oracle Enterprise Edition Azure Database for PostgreSQL Database $9,599 / month $19,801 / month $47,500* / per CPU $2,046.34 / month Virtual Private Database Included Included Included Row level security Partitioning Not included Included $11,500* / per CPU Included Data Guard Not included Not included $11,500* / per CPU Included Spatial Not included Included $17,500* / per CPU Included Diagnostics Included Included $7,500* / per CPU Included Tuning Pack Included Included $5,000* / per CPU Included Lifecycle Management Pack Not included Included $12,000* / per CPU Included as part of OSS tool suite Total Capex $0 $0 $1,800,000* $0 Annual Support / Maintenance per Server (Opex) Included Included $396,000** Included Total 3 Year Cost of Ownership $345,564 $712,836 $3,294,000*** $73,668 Estimates Only

Slide 14

Slide 14 text

Migration | Migrating a database Inventory database assets, and application stack discovery Assess workloads and fix recommen dations Convert the source schema to work in the target environment. This is only relevant for heterogeneous migrations. Remediate applications Iteratively make any necessary changes to your applications Run functional & performance tests Iteratively run functional and performance tests Optimize Based on the tests you performed, address any performance issues, and then retest to confirm the performance improvements Pre-migration Discover Assess Convert Migrate the source schema, and then migrate the source data to the target Sync your target schema and data with the source. This is only relevant for minimal- downtime migrations Cut over from the source to the target environment. This is only relevant for minimal- downtime migrations Migrate schema, data & objects Data sync Cutover Migration Post-migration

Slide 15

Slide 15 text

Use Ora2pg for assess and schema migration

Slide 16

Slide 16 text

Oracle to PostgreSQL End to End Migration Example • Schema Migration -ora2pg / Azure DMS • App/DB Migration • Stored procs in Oracle to Postgres – ora2pg • Oracle SQL Queries generated from application to PostgreSQL compatible queries- ora2pg • Drivers/ORMs for making databases agnostic – use PostgreSQL driver. • Ex: JDBC/Hibernate in Java. • Data Migration • Azure DMS – online data migration Azure DMS

Slide 17

Slide 17 text

Demo

Slide 18

Slide 18 text

Summary ich indexing and data types, (including geospatial). • Customers are moving from Oracle to Azure Database for PostgreSQL: - PL/PGSQL is highly compatible with PL/SQL making migrations easier and reducing risk. - TCO - Azure Database for PostgreSQL is based on community edition, no lock-in • Leverage Microsoft’s expertise, IP, and tooling to migrate from Oracle to PostgreSQL.

Slide 19

Slide 19 text

Resources https://datamigration.microsoft.com/scenario/oracle-to-azurepostgresql Migrate Oracle to Azure Database for PostgreSQL https://azure.microsoft.com/en-us/services/postgresql/ Azure Database for PostgreSQL [email protected] Ask Azure DB for PostgreSQL https://datamigration.microsoft.com/ Azure Database Migration Guide

Slide 20

Slide 20 text

Q&A Subject matter experts will be available to answer questions for the next 10 minutes. Please submit your questions using the Q&A window.

Slide 21

Slide 21 text

Thank you for joining us.