Forum Discussion

DRj_12's avatar
DRj_12
Copper Contributor
Dec 07, 2021

DMA - CREATE button is disabled with SQL DB Managed Instance as TARGET option.

Hi Everyone, 

Looking for some guidance re SQL DB migration through DMA tool.

When I select "target server type" as "Azure SQL Database Managed Instance" the CREATE button remains disabled (cant click). If I choose any other option for "target server type"  CREATE button does gets active. It is just when I select the ..managed instance.. as the target server type option CREATE does not become enabled. I have attached the screenshot. Please advise. This is my first post here, if you see I should be posting in some other forum please guide. Thank you!

1 Reply

Sort By
  • Wiliam_Rosa's avatar
    Wiliam_Rosa
    MCT
    Jun 11, 2022
    Please check the prerequisites:
    -Install the Azure SQL migration extension for Azure Data Studio.
    -Installed the Data Migration Assistant (DMA) on a machine that can connect to your source SQL Server.
    -Created a target Azure SQL Managed Instance
    -Configured connectivity and proper permissions to access both source and target.
    -Reviewed the SQL Server database engine features available in Azure SQL Managed Instance.

Resources