I was part of a talk on the subject of migrating on-premises web workloads and their supporting databases to Azure. The session allowed attendees to get familiar with migrating web applications and their supporting data workloads to Azure. There was far too much detail to cover in the short time we had in the workshop, so I put together a set of resources that will allow you to get deeper into the topic.
The links are divided up into different areas based on various migration topics. They include video, hands-on tutorials and official documentation. As this was a Microsoft talk, all the resources are from Microsoft.
Links From session
The following links were referenced during the session slides and demonstrations.
Migration Guide – Azure Database Migration Guide – Step-by-step guidance for modernizing your data assets. Detail sources that the workshop topic was based.
App Migration video – This video was used in DEMO 1. This demo shows you have to move your ASP.Net App or Site to Azure app service with the help of the new Azure App Service Migration Assistant. This assistant is a step-by-step guide for your assessment, migration and app optimization. This is a Microsoft video from Build.
1. General Introduction Azure Migration Assessment: Assess your apps, data, and infrastructure with Azure Migrate – By Microsoft Azure
2. Deep dive: Migrating and modernizing your data estate to Azure with Data Migration Services: Build 2018 – 90 minutes – Come learn all about Database Migration Service, and how anyone can utilize this service to migrate and modernize your data estate to fully managed services in Azure. From Build 2018.
These tutorials walk you through the various topics with hands-on examples. There are a couple of options for free Azure accounts.
Start building the future with Azure for Students! – Get a $100 credit when you create your free Azure for Students account
Azure free account FAQ – The Azure free account includes access to several Azure products that are free for 12 months. See the link for more details as this offer changes over time.
Tutorial:Tutorial: Migrate SQL Server to a single database or pooled database in Azure SQL Database online using DMS – In this tutorial, you migrate the Adventureworks2012 database restored to an on-premises instance of SQL Server 2016 (or later) to a single database or pooled database in Azure SQL Database by using the Azure Database Migration Service.
Tutorial: Migrate SQL Server to a single database or pooled database in Azure SQL Database online using DMS – In this tutorial, you migrate the Adventureworks2012 database restored to an on-premises instance of SQL Server 2016 (or later) to a single database or pooled database in Azure SQL Database by using the Azure Database Migration Service.
Tutorial: Tutorial: Migrate SQL Server to an Azure SQL Managed Instance offline using DMS – In this tutorial, you migrate the Adventureworks2012 database from an on-premises instance of SQL Server to a SQL Managed Instance by using Azure Database Migration Service.
AdventureWorks sample databases – These downloads are scripts and full database backups (.bak) files that you can use to install the AdventureWorks (OLTP) and AdventureWorksDW (data warehouse) sample databases to your SQL Server instance and these tutorials. The versions include SQL 2012/2014/2015/2017, which can demonstrate migration assessments of legacy database versions.
Migration and Assessment Resources
Migration Guide – Azure Database Migration Guide – Step-by-step guidance for modernizing your data assets
Azure migration center – This site provides resources and content that covers the entire move to the cloud, infrastructure, applications, and data to Azure.
Azure Migrate – Migrate infrastructure, applications, and data to Azure.
Database migration – Azure Database Migration Service – Azure Database Migration Service is a tool that helps you to simplify, guide and automate your database migration to Azure. Easily migrate your data, schema and objects from multiple sources to the cloud at scale.
Simplify your cloud migration: Azure Migration Program – Save money and bring your workloads to Azure with confidence. Use best-practice guidance, direct access to Azure engineers, tools, and subsidized partner services. Join the Azure Migration Program – Begin your migration journey by submitting an application to join the program.
Optimize cloud costs: Azure Free Account, Azure Cost Management + Billing – Moving to the cloud should also be done cost-effectively. Take advantage of the tools included in your Azure subscription to get more value out of the cloud and implement financial governance in your organization.
Azure TCO Calculator – Estimate your cost savings when you move your workloads to Azure. Enter the details of your on-premises workloads. This information will be used to understand your current TCO and recommended services in Azure.
Workshop Content: Workshop: SQL Ground-to-Cloud – Welcome to this Microsoft solutions workshop on SQL Server in on-premises, in-cloud and hybrid solutions. In this one-day workshop, you’ll learn how SQL Server 2019 and Azure SQL help you solve real-world challenges. The Modules in this workshop lead you through conceptual and hands-on topics ranging from the newest technical features in SQL Server to its implementation in all the platforms it runs on. You’ll learn not only specific technologies but how to assemble them into a complete solution based on customer needs and requests.
05 – Migrate to Azure SQL – In this module, you will use the Azure Database Migration Service (DMS) to migrate the TailspinToys database from the on-premises SQL 2008 R2 database to SQL MI. At the end of the module, you’ll also explore some of the security and performance features available.
Azure Database Migration Service – Ease your database migration to Azure Azure Database Migration Service is a tool that simplifies, guides and automates your database migration to Azure. Easily migrate your data, schema and objects from multiple sources to the cloud at scale.
SQL Server Migration Assistant – Microsoft SQL Server Migration Assistant (SSMA) is a tool designed to automate database migration to SQL Server from Microsoft Access, DB2, MySQL, Oracle, and SAP ASE.
Powerful tool for other projects also, such as performance, upgrades and testing Database Experimentation Assistant – Database Experimentation Assistant (DEA) is an experimentation solution for SQL Server upgrades. DEA can help you evaluate a targeted version of SQL Server for a specific workload. Customers upgrading from earlier versions of SQL Server (starting with 2005) to more recent SQL Server versions can use the analysis metrics that the tool provides.
Azure App Service Migration Assessment Tool – Assess your application’s readiness to migrate to App Service. Assess your site to get a detailed report of all the technologies used and whether they can be hosted on App Service. Assessment starts by providing a public endpoint scanned to provide a comprehensive list of technologies that are then compared to other sites hosted on App Service to generate a uniquely accurate assessment report for your website.
Azure Migrate documentation – Azure Migrate provides a central hub of tools for discovery, assessment, and migration of on-premises workloads to Azure.
Web Applications Migration Documentation and Tools – Simplify the migration of your web apps to the cloud with minimal or no code changes with the Azure App Service Migration Assistant tool – a free and straightforward path to migrate automatically .NET or PHP web applications from on-premises to the cloud.
Introducing the App Service Migration Assistant for ASP.NET applications – The Assessment Tool was designed to help customers quickly and easily assess whether a site could be moved to Azure App Service by scanning an externally accessible (HTTP) endpoint. Today we’re pleased to announce the release of an updated version, the App Service Migration Assistant! The new version helps customers and partners move sites identified by the assessment tool by quickly and easily migrating ASP.Net sites to App Service.
Video: Migrating web applications to Azure 50 Minute – In this session, we’ll look at how to migrate a frontend application to Azure, optimizing for speed and scale with Azure Storage. We’ll examine how to deploy, manage, monitor and backup both a Node.js and .NET Core API utilizing Azure App Service For Linux.