Hi @Vlasopoulos V ,
Welcome to Microsoft Q&A forum and thanks for using Azure services.
Regarding the issue which you have in Azure Data Studio - Azure SQL Migration extension thinks the Managed Instance is still in 'Creating' state.
Could you please try to close and re-open Azure Data Studio and give it a try if this helps.
If not, please let us know if you performing Online or Offline migration?
Also, I would request you to go through the Known Issues in Azure SQL Managed Instance limitations:
Migrating to Azure SQL Managed Instance by using the Azure SQL extension for Azure Data Studio has the following limitations:
- If migrating a single database, the database backups must be placed in a flat-file structure inside a database folder (including the container root folder), and the folders can't be nested, as it's not supported.
- If migrating multiple databases using the same Azure Blob Storage container, you must place backup files for different databases in separate folders inside the container.
- Overwriting existing databases using DMS in your target Azure SQL Managed Instance isn't supported.
- Configuring high availability and disaster recovery on your target to match source topology isn't supported by DMS.
- The following server objects aren't supported:
- SQL Server Agent jobs
- Credentials
- SSIS packages
- Server audit
- You can't use an existing self-hosted integration runtime created from Azure Data Factory for database migrations with DMS. Initially, the self-hosted integration runtime should be created using the Azure SQL migration extension in Azure Data Studio and can be reused for further database migrations.
- A single LRS job (created by DMS) can run for a maximum of 30 days. When this period expires, the job is automatically canceled thus your target database gets automatically deleted.
Please ensure these are checked.
Hope this should help. If not, please share inputs so that we may further assist.