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 ...
Get Microsoft Azure Essentials Migrating SQL Server Databases to Azure 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.
