Skip to Content

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.


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


A. Yes


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.

Microsoft Azure AI Fundamentals AI-900 certification exam practice question and answer (Q&A) dump

Alex Lim is a certified IT Technical Support Architect with over 15 years of experience in designing, implementing, and troubleshooting complex IT systems and networks. He has worked for leading IT companies, such as Microsoft, IBM, and Cisco, providing technical support and solutions to clients across various industries and sectors. Alex has a bachelor’s degree in computer science from the National University of Singapore and a master’s degree in information security from the Massachusetts Institute of Technology. He is also the author of several best-selling books on IT technical support, such as The IT Technical Support Handbook and Troubleshooting IT Systems and Networks. Alex lives in Bandar, Johore, Malaysia with his wife and two chilrdren. You can reach him at [email protected] or follow him on Website | Twitter | Facebook

    Ads Blocker Image Powered by Code Help Pro

    Your Support Matters...

    We run an independent site that is committed to delivering valuable content, but it comes with its challenges. Many of our readers use ad blockers, causing our advertising revenue to decline. Unlike some websites, we have not implemented paywalls to restrict access. Your support can make a significant difference. If you find this website useful and choose to support us, it would greatly secure our future. We appreciate your help. If you are currently using an ad blocker, please consider disabling it for our site. Thank you for your understanding and support.