您现在访问的是微软AZURE全球版技术文档网站,若需要访问由世纪互联运营的MICROSOFT AZURE中国区技术文档网站,请访问 https://docs.azure.cn.
将 SQL Server 数据库迁移到 Azure SQL 数据库SQL Server database migration to Azure SQL Database
02/11/2019
本文内容
适用于:
Azure SQL 数据库
本文介绍将 SQL Server 2005 或更高版本的数据库迁移到 Azure SQL 数据库的主要方法。In this article, you learn about the primary methods for migrating a SQL Server 2005 or later database to Azure SQL Database. For information on migrating to Azure SQL Managed Instance, see Migrate a SQL Server instance to Azure SQL Managed Instance. 有关选择迁移选项和迁移到 Azure SQL 的工具的指南,请参阅 迁移到 AZURE sqlFor guidance on choosing migration options and tools to migrate to Azure SQL, see Migrate to Azure SQL
迁移到单一数据库或共用数据库Migrate to a single database or a pooled database
将 SQL Server 2005 或更高版本的数据库迁移到 Azure SQL 数据库有两种主要方法。There are two primary methods for migrating a SQL Server 2005 or later database to Azure SQL Database. 第一种方法相对简单,但迁移过程中需要一段时间(可能较长)的停机。The first method is simpler but requires some, possibly substantial, downtime during the migration. 第二种方法更复杂,但在迁移过程中的停机时间大大缩短。The second method is more complex, but substantially eliminates downtime during the migration.
两种方法均需使用 Data Migration Assistant (DMA) 确保源数据库与 Azure SQL 数据库兼容。In both cases, you need to ensure that the source database is compatible with Azure SQL Database using the Data Migration Assistant (DMA). SQL 数据库除了要解决服务器级操作和跨数据库操作的相关问题之外,还要解决与 SQL Server 的功能奇偶一致性问题。SQL Database is approaching feature parity with SQL Server, other than issues related to server-level and cross-database operations. 依赖部分支持或不受支持的函数的数据库和应用程序需要进行某种程度的重新设计来修复这些不兼容性,然后才能迁移 SQL Server 数据库。Databases and applications that rely on partially supported or unsupported functions need some re-engineering to fix these incompatibilities before the SQL Server database can be migrated.
备