使用数据迁移助手标识 Stretch Database 的数据库和表Identify databases and tables for Stretch Database with Data Migration Assistant

本主题适用于:yesSQL Server(仅从 2016 开始的 Windows)noAzure SQL 数据库noAzure SQL 数据仓库no并行数据仓库THIS TOPIC APPLIES TO: yesSQL Server (Windows only starting with 2016)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

若要标识作为 Stretch Database 候选项的数据库和表,以及潜在的障碍,请下载并运行 Microsoft 数据迁移助手。To identify databases and tables that are candidates for Stretch Database, along with potential blocking issues, download and run Microsoft Data Migration Assistant.

获取数据迁移助手Get Data Migration Assistant

此处下载并安装数据迁移助手。Download and install Data Migration Assistant from here. 此工具不包含在 SQL Server 安装介质中。This tool is not included on the SQL Server installation media.

运行数据迁移助手Run Data Migration Assistant

  1. 运行 Microsoft 数据迁移助手。Run Microsoft Data Migration Assistant.

  2. 创建类型为“评估”的新项目并为其命名。Create a new project of type Assessment and give it a name.

  3. 选择“SQL Server”作为“源服务器类型”和“目标服务器类型”。Select SQL Server as both the Source server type and the Target server type.

  4. 选择“创建”。Select Create.

  5. 在“选项”页面(步骤 1)上,选择“新功能建议”。On the Options page (step 1), select New features recommendation. (可选)清除所选的“兼容性问题”。Optionally, clear the selection for Compatibility issues.

  6. 在“选择源”页面(步骤 2)上,连接到服务器,选择数据库,然后选择“添加”。On the Select sources page (step 2), connect to a server, select a database, and then select Add.

  7. 选择“开始评估”。Select Start Assessment.

查看结果Review the results

  1. 分析完成后,在“查看结果”页面(步骤 3)上,选择“功能建议”选项,然后选择“存储”选项卡。When the analysis is finished, on the Review results page (step 3), select the Feature recommendations option, and then select the Storage tab.

  2. 查看与 Stretch Database 相关的建议。Review the recommendations related to Stretch Database. 每项建议都列出了 Stretch Database 可能适合的表以及任何潜在的障碍。Each recommendation lists the tables for which Stretch Database may be appropriate, along with any potential blocking issues.

历史注释Historical note

Stretch Database 顾问之前是 SQL Server 2016 升级顾问的一个组件。Stretch Database Advisor was previously a component of SQL Server 2016 Upgrade Advisor. 那时,必须作为单独的操作选择并运行 Stretch Database 顾问。At that time, you had to select and run Stretch Database Advisor as a separate action.

随着数据迁移助手的发布,它替换并扩展了升级顾问,并将 Stretch Database 顾问的功能纳入到此新工具中。With the release of Data Migration Assistant, which replaces and extends Upgrade Advisor, the functionality of Stretch Database Advisor is incorporated into this new tool. 无需选择任何选项即可获取与 Stretch Database 相关的建议。You don't have to select any options to get recommendations related to Stretch Database. 当在数据迁移助手中运行评估时,与 Stretch Database 相关的结果将显示在“功能建议”的“存储”选项卡上。When you run an Assessment in Data Migration Assistant, the results related to Stretch Database appear on the Storage tab of the Feature recommendations.

下一步Next step

启用 Stretch Database。Enable Stretch Database.

另请参阅See Also

Stretch Database 的限制 Limitations for Stretch Database
Enable Stretch Database for a database Enable Stretch Database for a database
为表启用 Stretch DatabaseEnable Stretch Database for a table