Migrating a database to Azure
In Azure, you can migrate your database servers directly to Azure VMs (that is, a lift-and-shift), or you can migrate to Azure SQL Database using the PaaS model. The following figure shows the different relational database migration paths available in Azure and Azure Database Migration Service.
Figure 3.29 – Azure Database Migration Service
In most cases, companies decide to migrate to Azure SQL Managed Instance because it is simple to use with a minimal impact on business, especially if they have an additional requirement for SQL Server instance-level functionality. We can use it as a transition method to move to Azure SQL Database.
Azure SQL Database
Azure SQL Database is a relational Database as a Service (DaaS). It is a fully managed service, making it extremely easy to scale a database, something that was traditionally hard to do with a self-hosted SQL Server. You can also replicate a database in one or more...