Question 15 in AZ305 – Design Infrastructure Solutions

[edisonyls]

I have concern regarding the Migrate AppDB option. The suggested correct answer is to use Azure DMS to migrate the DB. However, the question states the following:
1. “50-TB database”
2. “The PHIInvManage application must continue to run on the same server as AppDB after migration”
3. “with the least administrative effort”

Given the above three points, isn’t Azure Migrate is a better choice since it will migrate the application with the least administrative effort, and it has high performance on transferring large scale database?

[Irene-TutorialsDojo]

Hello edisonyls,

Thank you for posting your concern.

To clarify the migration options: Azure Migrate is a tool that helps discover, assess, and plan your migration to Azure, including recommendations for target platforms and sizing. It can assess database readiness and provide guidance, but it does not itself perform the actual SQL Server database migration with minimal downtime. Instead, Azure Migrate is used to assess and plan, and for database movement, the actual data migration is performed by Azure Database Migration Service (DMS).

By contrast, Azure Database Migration Service is a fully managed service designed specifically to migrate SQL Server databases at scale with minimal downtime. It supports online migration, which keeps the source database operational during most of the migration and limits downtime to the final cutover phase, important for large databases like a 50-TB AppDB. DMS also automates schema and data movement and reduces administrative effort because it handles the database migration process end-to-end.

So in this scenario:

• Azure Migrate would help you assess and plan the migration, but would not replace the need for a database migration tool.

• Azure Database Migration Service is the recommended service to actually migrate AppDB to SQL Server on Azure with minimal downtime and operational effort.

I hope this helps clarify why Azure DMS is the correct recommendation for performing the database migration in your question.

Cheers,

Irene @ Tutorials Dojo