Save and load assessments with Data Migration Assistant

Important

Data Migration Assistant (DMA) is deprecated. For migration options from SQL Server to Azure SQL, see the migration options for SQL Server to Azure SQL.

The following step-by-step instructions help you use the Data Migration Assistant v5.0 or later to save a database assessment to a file, and then to load an assessment from a file.

In addition to loading assessments saved using the latest version of DMA, users can also use this feature to load assessments exported as .json files from previous versions of Data Migration Assistant to view the results in v5.0 and later.

Save an assessment to a file

  1. After running an assessment using Data Migration Assistant, select Save Assessment.

    Screenshot of Opening the Save Assessment dialog box.

    The standard Save... dialog box appears.

    Note

    For more information about how to run an assessment in Data Migration Assistant, see the article Perform a SQL Server migration assessment with Data Migration Assistant.

  2. Specify a name for the file, and then select Save.

    Screenshot of Naming and saving an assessment file.

Load an assessment saved to a file

  1. To load an assessment you've previously saved to a file, start Data Migration Assistant, and then on the All Assessments tab, select Load Assessment.

    Screenshot of Opening the Load Assessment dialog box.

  2. Navigate to the saved assessment file you want to load, select the file, and then select Open.

    Screenshot of Opening an assessment file.

    An entry for the assessment you loaded appears on the All Assessments tab.

    Screenshot of Displaying assessment entry.

  3. Select the assessment entry, and then select Open Assessment.

    Screenshot of Opening the assessment detail.

    Data Migration Assistant now displays details of the assessment you had run previously.

    Screenshot showing assessment detail.