Migrate from Oracle to PostgreSQL with Azure | Azure Webinar Series | Sai Srirampur & Saurabh Modi

Join this webinar to learn why more and more businesses are migrating their workloads from Oracle to PostgreSQL. Learn about the benefits of moving from Oracle to PostgreSQL and how our fully managed service, Azure Database for PostgreSQL, can help your organization.

You’ll also:

- Understand the business advantages of migrating from Oracle to PostgreSQL. 
- Learn why PostgreSQL has been known as the “most loved” operational database in open source.* 
- Discover additional benefits of migrating to Azure Database for PostgreSQL. 

Transcript

1. Migrate from Oracle
   to PostgreSQL with
   Azure
   Azure webinar series
   

   View Slide

2. 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
   

   View Slide

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

   View Slide

4. 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…
   

   View Slide

5. About Postgres
   

   View Slide

6. 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
   

   View Slide

7. 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
   

   View Slide

8. Extensions
   

   View Slide

9. © 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
   

   View Slide

10. Migrations
    

    View Slide

11. 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
    

    View Slide

12. 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
    

    View Slide

13. 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
    

    View Slide

14. 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
    

    View Slide

15. Use Ora2pg for assess and schema migration
    

    View Slide

16. 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
    

    View Slide

17. Demo
    

    View Slide

18. 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.
    

    View Slide

19. 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
    AskAzureDBforPostgreSQL@service.microsoft.com
    Ask Azure DB for PostgreSQL
    https://datamigration.microsoft.com/
    Azure Database Migration Guide
    

    View Slide

20. 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.
    

    View Slide

21. Thank you for joining us.
    

    View Slide