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



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.
651 questions
0 comments No comments
{count} votes

Accepted answer
  1. Alberto Morillo 32,006 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 comments No comments

0 additional answers

Sort by: Most helpful