1

I am not able to migrate on-premise SQL Server database to an Azure SQL database.

I am using Azure Data Studio while doing the migration. I am not able to "Select the tables" at the end, due to which I am not able to proceed next.

enter image description here

enter image description here

marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
Baxy
  • 139
  • 1
  • 13

3 Answers3

1

Please try to use Azure Data Migration Assistant (DMA) instead. You can download it from here. Perform an assessment first, you may need to fix some incompatibilities before migrating to Azure SQL. Once the incompatibilities have been fixed, try to migrate using DMA as explained here.

Alberto Morillo
  • 13,893
  • 2
  • 24
  • 30
1

if you want to migrate only the db without data, use .dacpac if you want to migrate with data generate a bacpac and import it.

However the best and most reliable method for a migration from on premise to azure sql db would be to use Data migration assistant. It will allow you to do a pre assessment before the migration to list any compatibility issues. You can fix the issues and do a migration using this utility.

Hijesh V L
  • 191
  • 1
  • 5
0

"Make sure to migrate the database schema from source to target by using the SQL Server dacpac extension or the SQL Database Projects extension in Azure Data Studio before selecting the list of tables to migrate."

Did you do this?

Yuan
  • 1
  • 1
  • As it’s currently written, your answer is unclear. Please [edit] to add additional details that will help others understand how this addresses the question asked. You can find more information on how to write good answers [in the help center](/help/how-to-answer). – Community Aug 07 '23 at 09:07