AI-900: How to migrate on-premises SQL databases to Azure SQL Databases

Learn about the benefits and methods of migrating on-premises SQL databases to Azure SQL Databases, a fully managed cloud service that offers high availability, scalability, performance, and security for SQL Server workloads.

Question

Tradewind Traders is planning to migrate to Azure cloud services but before they do, management has asked you to spend some time researching the Database solutions available in Azure specifically the ability to migrate existing on-premises SQL databases to Azure SQL Databases. Based on your research, is it possible to migrate directly?

A. Yes
B. No

Answer

A. Yes

Explanation

That’s correct, you can migrate your existing SQL Server databases with minimal downtime using the Azure Database Migration Service. The Azure Database Migration Service performs all the required steps. You just change the connection string in your apps.

The correct answer is A. Yes, it is possible to migrate directly from on-premises SQL databases to Azure SQL Databases. Azure SQL Database is a fully managed platform as a service (PaaS) that provides many benefits for SQL Server workloads, such as high availability, scalability, performance, and security. Azure SQL Database also supports various migration methods and tools to help users move their existing SQL Server databases to the cloud with minimal downtime and effort.

One of the migration methods is to use the Data Migration Assistant (DMA), which is a free tool that can assess the compatibility of on-premises SQL Server databases with Azure SQL Database, and then perform the migration using an online, offline, or hybrid mode. The online mode allows users to migrate their databases with minimal downtime, as it uses continuous data synchronization between the source and target until the cutover is complete. The offline mode migrates the databases in a single step, but requires more downtime, as the source database is unavailable during the migration. The hybrid mode is a combination of online and offline modes, where users can choose which tables to migrate online or offline.

Another migration method is to use the Azure Database Migration Service (DMS), which is a fully managed service that enables users to migrate multiple databases at scale from various sources to Azure SQL Database. DMS also supports online, offline, and hybrid modes, and provides a guided and automated experience to simplify the migration process. DMS can migrate databases from SQL Server, MySQL, PostgreSQL, Oracle, and MongoDB to Azure SQL Database.

Other migration methods include using BACPAC files, SQL Server Management Studio, Azure SQL migration extension for Azure Data Studio, and transactional replication. Each method has its own advantages and disadvantages, depending on the size, number, and complexity of the databases, as well as the acceptable downtime and performance impact during the migration. Users should evaluate their migration requirements and choose the most suitable method for their scenario.

Microsoft Azure AI Fundamentals AI-900 certification exam practice question and answer (Q&A) dump with detail explanation and reference available free, helpful to pass the Microsoft Azure AI Fundamentals AI-900 exam and earn Microsoft Azure AI Fundamentals AI-900 certification.