Chapter 2
Migrating a SQL Server Database to an Azure SQL Database
Learning Objectives
By the end of this lesson, you will be able to:
- Select a service tier for your migrated Azure SQL Database based on your needs
- Explain Database Transaction Units (DTUs)
- Identify and fix SQL Server-to-Azure SQL Database compatibility issues
- Migrate from an on-premises database to Azure SQL Database using different tools
In this lesson, you'll learn how to find and fix compatibility issues, determine an appropriate service tier, figure out a migration strategy and tool and migrate to the cloud.
Introduction
Migrating an on-premises SQL Server database is an important task and should be planned to perfection. An ideal migration methodology should be like ...
Get Professional Azure SQL Database Administration - Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
