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

[MarisaMathews]

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:

Data Migration Assistant
Capability
Azure Migrate
Run Data Migration Assistant from the command line
DMA command-line interface

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

[fmantovani]

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.... 

[fmantovani]

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
'