Blog Post

Azure SQL Blog
1 MIN READ

How to Assess Readiness of SQL Server Data Estate Migrating to Azure SQL | Data Exposed

MarisaMathews's avatar
MarisaMathews
Icon for Microsoft rankMicrosoft
Oct 22, 2020

With many organizations trying to migrate to Azure, one of the critical and most important tasks is to assess existing on-premise SQL Server instances and identify the right target Azure SQL. Data Migration Assistant (DMA) is a popular tool that helps in assessing SQL Server instance for a specific Azure SQL target and is immensely useful to gauge the readiness of SQL Server databases for migrating to Azure SQL. The capability to upload the DMA assessment results to the Azure Migrate hub to get a centralized readiness view of the entire data estate was already released. In this episode, Rajesh Setlem walks you through the steps for performing assessments at scale using DMA command-line interface (DMACMD).

 

Watch on Data Exposed 

 

Resources:
 

View/share our latest episodes on Channel 9 and YouTube!

Updated Oct 21, 2020
Version 1.0
azure sql

2 Comments

  • fmantovani's avatar
    fmantovani
    Copper Contributor
    May 27, 2021

    Hi MarisaMathews , it's me again. 

    How to log bugs regarding the DMACMD? 

     

    I found one that has no mention on google:

     

    DmaCmd.exe Information: 0 : 'Exception type: Microsoft.SqlServer.Fundamentals.OperationsInfrastructure.InputBinding.Contracts.SettingNullValueException
    Message:
        The specified value for 'AssessmentConfiguration' is invalid.  Only non-empty values are allowed
    HResult : 0x84BA000D
        FacilityCode : 1210 (4ba)
        ErrorCode : 13 (000d)
    Data:
        Microsoft.SqlServer.Fundamentals.OperationsInfrastructure.Contracts.ErrorFailureCategory = SettingValidationFailure
        SettingName = AssessmentConfiguration
'
  • fmantovani's avatar
    fmantovani
    Copper Contributor
    May 27, 2021

    Hello, 

    In your documentation I see there is the value AssessmentSourcePlatform. But such value has apparently only one option SqlOnPrem.

    Is there any other value for alternatives sources? 

    Otherwise what's the point.... :hearteyes: