Why enterprises are moving from Oracle to Azure Database for Postgres | Saurabh Modi | Ignite 2019

As companies evolve to their digital transformation, many also choose to modernize their data estate to better fit their elastic cloud-centric architecture. We are seeing a growing trend for enterprises who have historically relied on Oracle to move to a more flexible, lower cost and cloud-centric database architecture. Many of these are selecting Azure Postgres, particularly for transactional and low-latency business analytics. This session explores why customers are making this choice: the benefits of this move, as well as several business/technology strategies for making the move successful.

Transcript

1. Classified as Microsoft Confidential
   Why Enterprises are moving from Oracle
   to Azure Database for PostgreSQL
   

   View Slide

2. Classified as Microsoft Confidential
   Shyam Pitchaimuthu
   Product Manager, ECM
   

   View Slide

3. Classified as Microsoft Confidential
   Migration journey
   

   View Slide

4. Classified as Microsoft Confidential
   Downtime
   Back online
   

   View Slide

5. Classified as Microsoft Confidential
   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
   PostgreSQL is more popular than ever
   

   View Slide

6. Classified as Microsoft Confidential
   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

7. Classified as Microsoft Confidential
   Azure Database for PostgreSQL is available in
   two deployment options
   Single Server
   Fully-managed, single-node PostgreSQL
   Example use cases
   • Apps with JSON, geospatial support, or full-text search
   • Transactional and operational analytics workloads
   • Cloud-native apps built with modern frameworks
   Hyperscale (Citus)
   High-performance Postgres for scale out
   Example use cases
   • Scaling PostgreSQL multi-tenant, SaaS apps
   • Real-time operational analytics
   • Building high throughput transactional apps
   Enterprise-ready, fully
   managed community
   PostgreSQL with built-in HA
   and multi-layered security
   

   View Slide

8. Classified as Microsoft Confidential
   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
   MySQL: 5.6, 5.7, and 8.0 (public preview)
   PostgreSQL: 9.5, 9.6, 10, and 11
   MariaDB: 10.2
   

   View Slide

9. citusdata.com/newsletter
   Sign up for the
   Citus Newsletter
   

   View Slide

10. Classified as Microsoft Confidential
    Azure Database for PostgreSQL
    AskAzureDBforPostgreSQL@service.microsoft.com
    Azure Database Migration Guide
    

    View Slide