How to install the Full Adventure Works Dataware Database on Azure SQL Database

Michael Stoler 85 Reputation points


I would like to install the full AdventureWorksDW2020 on a Azure SQL Database.

What is the best way? Should I use SQL Server Management Studio?

Thank You,


Azure SQL Database
A cloud computing platform and infrastructure for building, deploying and managing applications and services through a worldwide network of Microsoft-managed datacenters.
252 questions
No comments
{count} votes

Accepted answer
  1. Alberto Morillo 26,131 Reputation points MVP

    Use the following steps:

    1. Create/restore the AdventureWorksDW database on a local SQL Server instance.
    2. Use Data Migration Assistant (DMA tool) to perform an assessment of the database using Azure SQL as target.
    3. Eradicate any incompatibilities of the database with Azure SQL.
    4. Use the DMA tool to migrate to Azure SQL as explained here.

    Hope this helps.

0 additional answers

Sort by: Most helpful