O'Reilly logo

Microsoft Azure Essentials Migrating SQL Server Databases to Azure by Carl Rabeler

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 4. Migrating a database to Azure

In this chapter, I will discuss migrating a user database to Azure. Your source database can be a Microsoft SQL Server database, or it can be any number of non-Microsoft SQL Server databases. Your destination database can be either SQL Server in an Azure virtual machine or Azure SQL Database. The migration method and complexity depend on your source database, your destination database, and your tolerance for downtime. I will discuss the migration options for each type of source database into both destination options. I will also briefly discuss managing metadata that is stored outside the user databases. Finally, I will briefly discuss setting the appropriate database compatibility level after the migration ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required