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

Published Oct 22 2020 09:00 AM 1,014 Views
Microsoft

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!

2 Comments
Senior Member

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:

 

Screenshot 2021-05-27 092833.png

Senior Member

Hi @MarisaBrasile , 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
'
%3CLINGO-SUB%20id%3D%22lingo-sub-1805250%22%20slang%3D%22en-US%22%3EHow%20to%20Assess%20Readiness%20of%20SQL%20Server%20Data%20Estate%20Migrating%20to%20Azure%20SQL%20%7C%20Data%20Exposed%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1805250%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EWith%20many%20organizations%20trying%20to%20migrate%20to%20Azure%2C%20one%20of%20the%20critical%20and%20most%20important%20tasks%20is%20to%20assess%20existing%20on-premise%20SQL%20Server%20instances%20and%20identify%20the%20right%20target%20Azure%20SQL.%20Data%20Migration%20Assistant%20(DMA)%20is%20a%20popular%20tool%20that%20helps%20in%20assessing%20SQL%20Server%20instance%20for%20a%20specific%20Azure%20SQL%20target%20and%20is%20immensely%20useful%20to%20gauge%20the%20readiness%20of%20SQL%20Server%20databases%20for%20migrating%20to%20Azure%20SQL.%20The%20capability%20to%20upload%20the%20DMA%20assessment%20results%20to%20the%20Azure%20Migrate%20hub%20to%20get%20a%20centralized%20readiness%20view%20of%20the%20entire%20data%20estate%20was%20already%20released.%20In%20this%20episode%2C%20Rajesh%20Setlem%20walks%20you%20through%20the%20steps%20for%20performing%20assessments%20at%20scale%20using%20DMA%20command-line%20interface%20(DMACMD).%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%20data-unlink%3D%22true%22%3E%3CFONT%20size%3D%225%22%3E%3CA%20href%3D%22https%3A%2F%2Fyoutu.be%2F2cG5OCW7HaM%3FWT.mc_id%3Ddataexposed-c9-niner%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3EWatch%20on%20Data%20Exposed%3C%2FA%3E%26nbsp%3B%3C%2FFONT%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CDIV%3E%3CEM%3EResources%3A%3C%2FEM%3E%3C%2FDIV%3E%0A%3CDIV%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fsql%2Fdma%2Fdma-overview%3Fview%3Dsql-server-ver15%3FWT.mc_id%3Ddataexposed-c9-niner%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EData%20Migration%20Assistant%3C%2FA%3E%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fsql%2Fdma%2Fdma-assess-sql-data-estate-to-sqldb%3Fview%3Dsql-server-ver15%3FWT.mc_id%3Ddataexposed-c9-niner%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3ECapability%3C%2FA%3E%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fmigrate%2Fmigrate-services-overview%3FWT.mc_id%3Ddataexposed-c9-niner%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EAzure%20Migrate%3C%2FA%3E%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fsql%2Fdma%2Fdma-commandline%3Fview%3Dsql-server-ver15%26amp%3BWT.mc_id%3Ddataexposed-c9-niner%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3ERun%20Data%20Migration%20Assistant%20from%20the%20command%20line%3C%2FA%3E%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fsql%2Fdma%2Fdma-assess-sql-data-estate-to-sqldb-commandline%3Fview%3Dsql-server-2017%26amp%3BWT.mc_id%3Ddataexposed-c9-niner%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EDMA%20command-line%20interface%3C%2FA%3E%3C%2FDIV%3E%0A%3CDIV%3E%26nbsp%3B%3C%2FDIV%3E%0A%3CP%3E%3CSPAN%3EView%2Fshare%20our%20latest%26nbsp%3Bepisodes%20on%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fchannel9.msdn.com%2FShows%2FData-Exposed%3FWT.mc_id%3Ddataexposed-c9-niner%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EChannel%209%3C%2FA%3E%26nbsp%3Band%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fwww.youtube.com%2Fplaylist%3Flist%3DPLlrxD0HtieHieV7Jls72yFPSKyGqycbZR%26amp%3BWT.mc_id%3Ddataexposed-c9-niner%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3EYouTube%3C%2FA%3E%3C%2FSPAN%3E!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-1805250%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22MSDataExposed.jpg%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F201130iE9AAF33173512AF8%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22MSDataExposed.jpg%22%20alt%3D%22MSDataExposed.jpg%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%3ELearn%20how%20to%20get%20a%20centralized%20readiness%20view%20of%20a%20SQL%20Server%20Data%20Estate%20Migration%20to%20Azure%20SQL.%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-TEASER%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1805250%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAzure%20SQL%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Version history
Last update:
‎Oct 21 2020 12:01 PM
Updated by: