Challenge 1 - Migration

< Previous Challenge - Home - Next Challenge >

Introduction

Your fledgling company has two migration tasks at hand. In both cases, your clients would like to migrate their SQL Server instances into Azure. Each solution has different requirements.

Description

The objective of this challenge is to migrate AdventureWorks and WWI Databases (OLTP and OLAP) to Azure. Each presents a unique set of customer requirements; be sure to read the optional advanced challenges – while completing the advanced challenges is not required for this challenge, it may impact your implementation choices.

AdventureWorks

AdventureWorks has provided the following requirements and guidelines:

1. Must take advantage of PaaS services for easier administration.
2. Database must be able to scale rapidly and easily for seasonal demand.
3. Requires database backups to be maintained for 1 year, with weekly granularity.
4. Database can be migrated offline during one of the nightly maintenance windows.
5. If there are any migration blockers/remediation steps, document them with any suggested fixes.
   1. These fixes do not need to be implemented, but should be called out.

Wide World Importers

Wide World Importers has provided the following requirements and guidelines:

1. Both WWI OLTP and data warehouse databases are to be migrated; they do not need to be on the same server.
2. Wide World Importers would prefer to take advantage of PaaS services if possible.
3. Database migration for the OLTP database must be done online with minimum downtime.
   1. For the purposes of this challenge, use the WWI Order Insert Solution (Windows Application) to simulate load on the on-premises database during migration/assessment.
4. Database migration for the data warehouse can be done offline.
5. SSIS package as part of the WWI DW ETL is a bonus challenge and not required.

Success Criteria

• Ensure AdventureWorks database is migrated, noting any blockers with suggestions for remediation.
• Complete a database assessment of the Wide World Importers OLTP database.
• Complete online migration of the Wide World Importers database.

Tips

• Learn about the Azure Database Migration Service and leverage the Azure Database Migration Guide.
• Read up on Microsoft Data Migration Assistant including this overview for more information.
• Read more on getting started with Azure Data Studio, and refer to this Azure Data Studio Quickstart for more information.
• Any assessment tool may be used to perform an assessment; DMA (Data Migration Assistant) includes assessment and SKU recommendation tools.
• Provisioning of some resources, such as Azure SQL Managed Instance, can take some time (potentially several hours, though it typically faster).

Advanced Challenges (Optional)

• Migrate WWI DW to Azure Synapse Analytics (Azure SQL DW).
• Migrate WWI DW SSIS ETL to either ADF or Synapse Pipelines.
• WWI is interested in understanding the performance impact of zone redundant availability.
  • Use Query Store, Database Experimentation Assistant, or other similar analytics to provide data to back up your analysis; workloads may be simulated using the WWI Order Insert Solution referenced above.

Learning Resources

• Azure SQL Fundamentals
• Download the Workload Driver solution or executable here:
  • WWI Order Insert Solution
  • WWI Order Insert Executable (workload-drivers.zip)