Skip to main content Link Menu Expand (external link) Document Search Copy Copied
Migrate Windows & SQL workloads to Azure

Task 02 - Assess on-premises database compatibility

Introduction

Tailspin Toys wants to migrate their on-premises SQL Server database to Azure SQL Managed Instance. In this second task, you will run an assessment to check the database compatibility of the on-prem SQL Server database.

Description

In this task, you will run an assessment to check the database compatibility of the on-prem SQL Server database.

The key tasks are as follows:

  1. Create a new migration project.
  2. Add the on-prem database as source.
  3. Run the database migration assessment.

Success Criteria

  • Created a database migration project.
  • Data Migration Assistant showing there are no compatibility issues.

Solution

Expand this section to view the solution

  1. Run the Microsoft Data Migration Assistant previously installed.

    The Data Migration Assistant application is shown.

  2. On the left, select the Plus sign (+) button to create a new project, and enter the following values, then select Create.

    • Project type: Assessment
    • Project name: Tailspin
    • Assessment type: Database Engine
    • Source server type: SQL Server
    • Target server type: Azure SQL Database Managed Instance

    The New project dialog is shown with the required values entered in the fields.

  3. On the Options tab, ensure the Check database compatibility and Check feature parity report types are selected, then select Next.

    The Options step is shown with Check database compatibility and Check feature parity options selected.

  4. On the Connect to a server prompt, enter localhost for the Server name, and check the Trust server certificate option, then select Connect.

    The Connect to a server dialog box is shown with the values entered to connect to localhost and to trust the server certificate.

  5. On the Add sources prompt, select the WideWorldImporters database, then select Add.

    The Add sources dialog box is shown with the WideWorldImporters database selected.

  6. Select Start Assessment in the lower right.

    The Select sources step is shown with the WideWorldImporters database shown as previously selected and the Start Assessment button is highlighted.

  7. On the Review results pane, you should see a message that states, “There are no feature parity issues with your server instance.”

    The Review results step is shown with the 'There are no feature parity issues with your server instance' message shown.

  8. On the top left of the Review results pane, select Compatibility issues.

    The Compatibility issues option is selected on the Review results pane.

  9. On the Review results pane, you should see a message that “There are no compatibility issues with your database”.

    The Review results pane is shown with Compatibility issues selected and showing the 'There are no compatibility issues with your database' message shown.

  10. The Data Migration Assessment is complete. If there were feature parity or compatibility issues found, then you would need to address those before migrating the SQL Server database to Azure SQL MI.