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

Anonymous
2023-03-03T01:43:26.1366667+00:00

Hello,

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,

Michael

Azure SQL Database
Azure
Azure
A cloud computing platform and infrastructure for building, deploying and managing applications and services through a worldwide network of Microsoft-managed datacenters.
923 questions
0 comments
Accepted answer
  1. Alberto Morillo 32,806 Reputation points MVP
    2023-03-03T03:40:33.3433333+00:00

    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

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest