looking to upload Adventureworksdw2019 to Azure SQL

Anonymous
2023-03-07T16:25:52.84+00:00

Hello,

What is the best way to upload the full AdventureWorksDW2019 to Azure SQL Database?

I was looking at the Azure Data Studio Migration tool which I believe requires me to first create the schema on Azure SQL and then migrate?

Is there a more direct way?

Thank You,

Michael

Azure Data Studio
Azure Data Studio
A cross-platform database tool for data professionals using on-premises and cloud data platforms on Windows, macOS, and Linux.
97 questions
0 comments No comments
{count} votes

Accepted answer
  1. Luke Murray 10,526 Reputation points MVP
    2023-03-07T20:33:52.6233333+00:00

    Hi, Michael

    You can restore with ADM but you can also restore using SQL Management Studio.

    If you upload the backup file to an Azure storage blob container, you can then use SQL Server Management Studio, to restore the backup from the blob container.


0 additional answers

Sort by: Most helpful