Database Modernization (Azure SQL Database)
Download as pptx, pdf0 likes147 views
This document discusses database modernization and migration to the cloud. It outlines the various data store models available in Azure, including relational, NoSQL, and analytics databases. It then covers migrating relational databases like SQL Server to Azure SQL Database or SQL Managed Instance. The migration roadmap involves assessing the on-premises environment, planning the target cloud platform and migration approach, transforming the database schema if needed, performing the migration, and validating the results. Selecting the right Azure service tier and features is important. Tools like DMA and DMS can assist with the migration process.
More Related Content
Similar to Database Modernization (Azure SQL Database) (17)
Recently uploaded (20)
Database Modernization (Azure SQL Database)
- 1. @RADUVUNVULEA Azure Tech Series Database Modernization
- 2. THE “CLOUD DISILLUSIONMENT” BLOSSOMS BECAUSE THE METER IS ALWAYS RUNNING
- 3. THE BIGGEST ADVANTAGE PRESENTED BY MODERN CLOUD TECHNOLOGY IS THE ABILITY FOR SMALL TO MID-SIZE COMPANIES TO LEVEL THE PLAYING FIELD
- 4. BY 2025, 80% OF ENTERPRISES WILL SHUT DOWN THEIR TRADITIONAL DATA CENTERS AND SHIFT TO PUBLIC CLOUD
- 5. THE HYBRID CLOUD IS THE WEAPON OF CHOICE FOR 45% OF ENTERPRISES
- 6. Innovation Secure Database modernization ScalableReliable Easy to manage Reduce complexity Increase agility
- 8. FORGET DMS SQL Database Advisor Automatic Tuning TDE SQL Threat Detection Backups
- 9. 9 Agenda 1. AZURE DATA STORE MODELS 2. OUTLINE OF RDBMS FLAVORS 3. SQL MIGRATION STEPS AND TIPS
- 11. RELATIONALDATABASE AZURE SQL DATABASE AZURE DATABASE FOR MYSQL AZURE DATABASE FOR POSTGRESQL AZURE DATABASE FOR MARIADB
- 12. KEY/VALUESSTORES AZURE SQL DATABASE AZURE DATABASE FOR MYSQL AZURE DATABASE FOR POSTGRESQL AZURE DATABASE FOR MARIADB AZURE COSMOSDB AZURE CACHE FOR REDIS AZURE TABLE
- 13. DOCUMENTDATABASE AZURE SQL DATABASE AZURE DATABASE FOR MYSQL AZURE DATABASE FOR POSTGRESQL AZURE DATABASE FOR MARIADB AZURE COSMOSDB AZURE CACHE FOR REDIS AZURE TABLE AZURE COSMOSDB
- 14. GRAPHDATABASE AZURE SQL DATABASE AZURE DATABASE FOR MYSQL AZURE DATABASE FOR POSTGRESQL AZURE DATABASE FOR MARIADB AZURE COSMOSDB AZURE CACHE FOR REDIS AZURE TABLE AZURE COSMOSDB AZURE COSMOS DB GREMLIN API SQL SERVER
- 15. DATAANALYTICS AZURE SQL DATABASE AZURE DATABASE FOR MYSQL AZURE DATABASE FOR POSTGRESQL AZURE DATABASE FOR MARIADB AZURE COSMOSDB AZURE CACHE FOR REDIS AZURE TABLE AZURE COSMOSDB AZURE COSMOS DB GREMLIN API SQL SERVER AZURE SYNAPSE ANALYTICS AZURE DATA LAKE AZURE DATA EXPLORER AZURE ANALYSIS SERVICES HDINSIGHT AZURE DATABRICKS
- 16. COLUMN-FAMILYDATABASES AZURE SQL DATABASE AZURE DATABASE FOR MYSQL AZURE DATABASE FOR POSTGRESQL AZURE DATABASE FOR MARIADB AZURE COSMOSDB AZURE CACHE FOR REDIS AZURE TABLE AZURE COSMOSDB AZURE COSMOS DB GREMLIN API SQL SERVER AZURE SYNAPSE ANALYTICS AZURE DATA LAKE AZURE DATA EXPLORER AZURE ANALYSIS SERVICES HDINSIGHT AZURE DATABRICKS AZURE COSMOS DB CASSANDRA API HBASE IN HDINSIGHT
- 17. SEARCHENGINEDATABASE AZURE SQL DATABASE AZURE DATABASE FOR MYSQL AZURE DATABASE FOR POSTGRESQL AZURE DATABASE FOR MARIADB AZURE COSMOSDB AZURE CACHE FOR REDIS AZURE TABLE AZURE COSMOSDB AZURE COSMOS DB GREMLIN API SQL SERVER AZURE SYNAPSE ANALYTICS AZURE DATA LAKE AZURE DATA EXPLORER AZURE ANALYSIS SERVICES HDINSIGHT AZURE DATABRICKS AZURE COSMOS DB CASSANDRA API HBASE IN HDINSIGHT AZURE SEARCH
- 18. TIMESERIESDATABASE AZURE SQL DATABASE AZURE DATABASE FOR MYSQL AZURE DATABASE FOR POSTGRESQL AZURE DATABASE FOR MARIADB AZURE COSMOSDB AZURE CACHE FOR REDIS AZURE TABLE AZURE COSMOSDB AZURE COSMOS DB GREMLIN API SQL SERVER AZURE SYNAPSE ANALYTICS AZURE DATA LAKE AZURE DATA EXPLORER AZURE ANALYSIS SERVICES HDINSIGHT AZURE DATABRICKS AZURE COSMOS DB CASSANDRA API HBASE IN HDINSIGHT AZURE SEARCH AZURE TIME SERIES INSIGHTS
- 19. OBJECTSTORAGE AZURE SQL DATABASE AZURE DATABASE FOR MYSQL AZURE DATABASE FOR POSTGRESQL AZURE DATABASE FOR MARIADB AZURE COSMOSDB AZURE CACHE FOR REDIS AZURE TABLE AZURE COSMOSDB AZURE COSMOS DB GREMLIN API SQL SERVER AZURE SYNAPSE ANALYTICS AZURE DATA LAKE AZURE DATA EXPLORER AZURE ANALYSIS SERVICES HDINSIGHT AZURE DATABRICKS AZURE COSMOS DB CASSANDRA API HBASE IN HDINSIGHT AZURE SEARCH AZURE TIME SERIES INSIGHTS AZURE BLOB STORAGE AZURE DATA LAKE STORAGE GEN2
- 20. SHAREDFILES AZURE SQL DATABASE AZURE DATABASE FOR MYSQL AZURE DATABASE FOR POSTGRESQL AZURE DATABASE FOR MARIADB AZURE COSMOSDB AZURE CACHE FOR REDIS AZURE TABLE AZURE COSMOSDB AZURE COSMOS DB GREMLIN API SQL SERVER AZURE SYNAPSE ANALYTICS AZURE DATA LAKE AZURE DATA EXPLORER AZURE ANALYSIS SERVICES HDINSIGHT AZURE DATABRICKS AZURE COSMOS DB CASSANDRA API HBASE IN HDINSIGHT AZURE SEARCH AZURE TIME SERIES INSIGHTS AZURE BLOB STORAGE AZURE DATA LAKE STORAGE GEN2 AZURE FILES
- 21. OUTLINE
- 22. SQL Server Azure SQL Database Azure SQL Managed Instance
- 23. AWS RDS SQL Server Azure SQL Database Azure SQL Managed Instance
- 24. MySQL Azure Database for MySQL Azure Database for PostgreSQLPostgreSQL Maria DB > Azure Database for MariaDB
- 25. MongoDB Azure Cosmos DB Mongo DB API Azure Cosmos DB Cassandra API Cassandra
- 28. Always Encrypted & Transparent Data Encryption
- 30. Active geo-replication & Automatic backups
- 32. INITIATE AND DISCOVER ASSESSMENT PLAN TRANSFORM AND OPTIMIZE MIGRATE, VALIDATE AND REMEDIATE 1 2 3 4 5 ASSESS THE DISCOVERED WORKLOAD REQUIREMENTS AND ANY DEPENDENCIES UNDERSTAND YOUR DATABASE FOOTPRINT AND POTENTIAL APPROACHES TO MIGRATION PLAN AND DESCRIBE THE WORKLOADS TO BE MIGRATED, THE TOOL TO BE USED FOR MIGRATION AND THE TARGET PLATFORM FOR THE WORKLOAD TRANSFORM ANY WORKLOADS NOT CURRENTLY COMPATIBLE WITH MODERN DATA PLATFORMS. OPTIMIZE WORKLOADS TO TAKE ADVANTAGE OF NEW FEATURES PERFORM MIGRATION, VALIDATE SUCCESSFUL MIGRATION, AND REMEDIATE APPLICATIONS WHERE REQUIRED
- 33. INITIATEANDDISCOVER THE INVENTORY OF YOUR DATA ESTATE APPLICATION DATABASE DEPENDENCIES WHAT DATABASES MOVE TOGETHER
- 34. INITIATEANDDISCOVER THE INVENTORY OF YOUR DATA ESTATE APPLICATION DATABASE DEPENDENCIES WHAT DATABASES MOVE TOGETHER Database Migration Guide Microsoft Assessment & Planning (MAP) Toolkit Data Migration Assistant (DMA)
- 36. ASSESSMENT THE MIGRATION BLOCKERS BREAKING CHANGES & EFFORT INVOLVED TO FIX ISSUES FEATURES TO LEVERAGE
- 37. ASSESSMENT THE MIGRATION BLOCKERS BREAKING CHANGES & EFFORT INVOLVED TO FIX ISSUES FEATURES TO LEVERAGE Performance requirements DTU CPU, memory and I/O vCores logical CPU AZURE SQL DATABASE DTU
- 38. ASSESSMENT THE MIGRATION BLOCKERS BREAKING CHANGES & EFFORT INVOLVED TO FIX ISSUES FEATURES TO LEVERAGE Performance requirements Quality metrics Availability, Disaster recovery, Migration downtown, Compliance, 3rd party workloads
- 39. ASSESSMENT THE MIGRATION BLOCKERS BREAKING CHANGES & EFFORT INVOLVED TO FIX ISSUES FEATURES TO LEVERAGE DMA LEGACY SQL SERVER DMA AZURE (1) ASSESS AND IDENTIFY ISSUES (2) FIX ISSUES (3) DEPLOY SCHEMA
- 40. PLAN TARGET PLATFORM ONE-TIME MIGRATION VERSUS CONTINUOUS SYNC
- 41. PLAN TARGET PLATFORM ONE-TIME MIGRATION VERSUS CONTINUOUS SYNC Target platform Azure (IaaS) Azure SQL Database (PaaS) SQL Server Managed instances Single Elastic Pool
- 42. PLAN TARGET PLATFORM ONE-TIME MIGRATION VERSUS CONTINUOUS SYNC Target platform Azure SQL Database (Single) DTU Basic | dev/test Standard | normal loads Premium | mission critical
- 43. PLAN TARGET PLATFORM ONE-TIME MIGRATION VERSUS CONTINUOUS SYNC Target platform Azure SQL Database (Single) vCore General Purpose | good performance and cost Business Critical | high IO requirements . ..
- 44. PLAN TARGET PLATFORM ONE-TIME MIGRATION VERSUS CONTINUOUS SYNC Target platform Elastic Pool Resources allocated to a pool of databases High no. of DBs with low utilization Basic | Standard | Premium
- 45. PLAN TARGET PLATFORM ONE-TIME MIGRATION VERSUS CONTINUOUS SYNC Target platform Azure SQL Database Managed Instance Broad SQL Server compatibility and network isolation Same features as Azure SQL Database Useful for lift and shift scenarios
- 46. PLAN TARGET PLATFORM ONE-TIME MIGRATION VERSUS CONTINUOUS SYNC Target platform SQL Server on Azure VMs Customized environment with full administrative rights Fully supports SQL Server transactional replication, AlwaysOn Availability Groups, Integration Services, Log Shipping to replicate data, and traditional SQL Server backups
- 47. PLAN How to choose Features TCO Usage Scenarios SQL AGENT MSDTC DQS MDS DATABASE MAIL FILESTREAM FILETABLE POLYBASE Azure SQL Database Managed Instance
- 48. PLAN Migration plan Quality attributes LARGE MAINTENANCE WINDOW BACPAC – IMPORT/EXPORT Critical LowHigh ZERO DOWNTIME SSMS (SQL SERVER MANAGEMENT STUDIO) SMALL MAINTENANCE WINDOW DMS (AZURE DATABASE MIGRATION SERVICE
- 49. PLAN
- 50. TRANSFORMANDOPTIMIZE SCHEMA COMPATIBLE WITH TARGET PREPARATIONS COMPLETE FOR DATA MIGRATION
- 51. TRANSFORMANDOPTIMIZE SCHEMA COMPATIBLE WITH TARGET PREPARATIONS COMPLETE FOR DATA MIGRATION UPDATE AND CHECK DB SCHEMA VERSION UPGRADE AND SSIS WORKLOADS FIX ERRORS AND WARNINGS AND 3rd PARTY INTEGRATION
- 53. MIGRATE,VALIDATEANDREMEDIATE THE MIGRATION ITSELF START WITH LOW PRIORITY DB USE AZURE DMS AS MUCH AS POSSIBLE RUN TEST MIGRATIONS
- 54. FINAL THOUGHTS
Editor's Notes
- #10: Agenda General Template Guidance: Information to help you make good presentations. Standard / Static Slides: Some key Endava slides/lockups that, in general, should only be modified by marketing. Template Slides: A selection of template slides for use in Endava presentations. Larger Format Template Slides: Template slides with larger content. Icon Library: A selection of hundreds of icons to use in Endava presentations.