Migration failed with internal error while restoring database

[ingebeumer]

Issue Type: Bug

Hi all,
Using Azure SQL Migration extension in Azure Data Studio for a migration of WideWorldImportersDW from local SQL Server 2019 to Azure SQL Managed Instance I get a message:
"Migration for Database 'WideWorldImportersDW_offline_fromADS' failed with error 'An internal error occurred while restoring the database. Please retry the restore request later.'."
Retrying restore later and even the next day gave the same error.

Manual restore from SSMS had a more meaningful message indicating the issue:
'Msg 41915, Level 16, State 1, Line 13
Memory-optimized filegroup must be empty in order to be restored on General Purpose tier of SQL Database Managed Instance.
Msg 3013, Level 16, State 1, Line 13
RESTORE DATABASE is terminating abnormally'

After taking the easy route and scaling my Managed instance from General Purpose service tier to Business Critical, the migration was successful, ending in "migrationState": "Succeeded".

Please review if the message in Azure SQL Migration extension is eligible for improvement to give a more meaningful message leading to easier troubleshooting.

Thank you and kind regards, Inge

Extension version: 0.1.8
Azure Data Studio version: azuredatastudio 1.32.0 (4a45ba7, 2021-08-16T18:08:28.086Z)
OS version: Windows_NT x64 10.0.22473

System Info

Item	Value
CPUs	Intel(R) Core(TM) i7-1065G7 CPU @ 1.30GHz (8 x 1498)
GPU Status	2d_canvas: enabled gpu_compositing: enabled multiple_raster_threads: enabled_on oop_rasterization: enabled opengl: enabled_on rasterization: enabled skia_renderer: enabled_on video_decode: enabled vulkan: disabled_off webgl: enabled webgl2: enabled
Load (avg)	undefined
Memory (System)	15.60GB (4.33GB free)
Process Argv
Screen Reader	yes
VM	0%

[raymondtruong]

Our service has been updated to improve error messaging and now includes a troubleshooting link to further assist with configuration issues. If this issue still persists, feel free to reopen the issue.