Data Migration Assistant 概觀 (機器翻譯)Overview of Data Migration Assistant

Data Migration Assistant (DMA) 藉由偵測可能影響新版本 SQL Server 或 Azure SQL Database 中資料庫功能的相容性問題,協助您升級至新式資料平臺。The Data Migration Assistant (DMA) helps you upgrade to a modern data platform by detecting compatibility issues that can impact database functionality in your new version of SQL Server or Azure SQL Database. DMA 可為您的目標環境提供效能和可靠性改善的建議,並可讓您將結構描述、資料和非內含的物件從來源伺服器移至目標伺服器。DMA recommends performance and reliability improvements for your target environment and allows you to move your schema, data, and uncontained objects from your source server to your target server.


針對大型遷移 () 的資料庫數目和大小,我們建議您使用Azure 資料庫移轉服務,其可大規模地遷移資料庫。For large migrations (in terms of number and size of databases), we recommend that you use the Azure Database Migration Service, which can migrate databases at scale.

取得 Data Migration AssistantGet Data Migration Assistant

若要安裝 DMA,請從Microsoft 下載中心下載最新版的工具,然後執行DataMigrationAssistant.msi檔案。To install DMA, download the latest version of the tool from the Microsoft Download Center, and then run the DataMigrationAssistant.msi file.


  • 評估內部部署 SQL Server 實例 (s) 遷移至 Azure SQL database (s) 。Assess on-premises SQL Server instance(s) migrating to Azure SQL database(s).評估工作流程可協助您偵測下列可能會影響 Azure SQL database 遷移的問題,並提供如何解決這些問題的詳細指引。 The assessment workflow helps you to detect the following issues that can affect Azure SQL database migration and provides detailed guidance on how to resolve them.

    • 遷移封鎖問題:探索封鎖將內部部署 SQL Server 資料庫 (s) 遷移至 Azure SQL Database (s) 的相容性問題。Migration blocking issues: Discovers the compatibility issues that block migrating on-premises SQL Server database(s) to Azure SQL Database(s).DMA 提供的建議可協助您解決這些問題。 DMA provides recommendations to help you address those issues.

    • 部分支援或不支援的功能:偵測目前在來源 SQL Server 實例上使用的部分支援或不支援的功能。Partially supported or unsupported features: Detects partially supported or unsupported features that are currently in use on the source SQL Server instance.DMA 提供一組完整的建議、Azure 中可用的替代方法,以及減少步驟,讓您可以將它們併入您的遷移專案。 DMA provides a comprehensive set of recommendations, alternative approaches available in Azure, and mitigating steps so that you can incorporate them into your migration projects.

  • 找出可能影響升級至內部部署 SQL Server 的問題。Discover issues that can affect an upgrade to an on-premises SQL Server.這些會描述為相容性問題,並以下列類別進行組織: These are described as compatibility issues and are organized in the following categories:

    • 重大變更Breaking changes
    • 行為變更Behavior changes
    • 已淘汰的功能Deprecated features
  • 探索目標 SQL Server 平臺中,資料庫在升級後可受益的新功能。Discover new features in the target SQL Server platform that the database can benefit from after an upgrade. 這些會描述為功能建議,並以下列類別進行組織:These are described as feature recommendations and are organized in the following categories:

    • 效能Performance
    • 安全性Security
    • 儲存體Storage
  • 將內部部署 SQL Server 實例遷移至裝載于內部部署或 Azure 虛擬機器 (VM) (可從您的內部部署網路存取)上裝載的新式 SQL Server 實例。Migrate an on-premises SQL Server instance to a modern SQL Server instance hosted on-premises or on an Azure virtual machine (VM) that is accessible from your on-premises network. 您可以使用 VPN 或其他技術來存取 Azure VM。The Azure VM can be accessed using VPN or other technologies. 遷移工作流程可協助您遷移下列元件:The migration workflow helps you to migrate the following components:

    • 資料庫的架構Schema of databases
    • 資料和使用者Data and users
    • 伺服器角色Server roles
    • SQL Server 和 Windows 登入SQL Server and Windows logins
  • 成功遷移之後,應用程式就可以順暢地連接到目標 SQL Server 資料庫。After a successful migration, applications can connect to the target SQL Server databases seamlessly.

  • 評估內部部署 SQL Server Integration Services (SSIS) 套件 (s) 遷移至 Azure SQL Database 或 Azure SQL 受控執行個體。Assess on-premises SQL Server Integration Services (SSIS) package(s) migrating to Azure SQL Database or Azure SQL Managed Instance. 評量有助於找出可能影響遷移的問題。The assessment helps to discover issues that can affect the migration. 這些會描述為相容性問題,並以下列類別進行組織:These are described as compatibility issues and are organized in the following categories:

    • 遷移封鎖程式:探索阻止將來源套件 (s) 遷移至 Azure 的相容性問題。Migration blockers: discovers the compatibility issues that block migrating source package(s) to Azure. DMA 提供的建議可協助您解決這些問題。DMA provides recommendations to help you address those issues.

    • 資訊問題:偵測部分支援或已淘汰的功能,用於來源套件 (s) 。Information issues: detects partially supported or deprecated features that are used in source package(s).


若要執行評量,您必須是 SQL Server系統管理員(sysadmin )角色的成員。To run an assessment, you have to be a member of the SQL Server sysadmin role.

支援的來源和目標版本Supported source and target versions

DMA 會取代所有舊版的 SQL Server Upgrade Advisor,而且應該用於大部分 SQL Server 版本的升級。DMA replaces all previous versions of SQL Server Upgrade Advisor and should be used for upgrades for most SQL Server versions. 支援的來源和目標版本包括:Supported source and target versions are:


  • SQL Server 2005SQL Server 2005
  • SQL Server 2008SQL Server 2008
  • SQL Server 2008 R2SQL Server 2008 R2
  • SQL Server 2012SQL Server 2012
  • SQL Server 2014SQL Server 2014
  • SQL Server 2016SQL Server 2016
  • Windows 上的 SQL Server 2017SQL Server 2017 on Windows


  • SQL Server 2012SQL Server 2012
  • SQL Server 2014SQL Server 2014
  • SQL Server 2016SQL Server 2016
  • Windows 和 Linux 上的 SQL Server 2017SQL Server 2017 on Windows and Linux
  • SQL Server 2019SQL Server 2019
  • Azure SQL Database 單一資料庫Azure SQL Database single database
  • Azure SQL 受控執行個體Azure SQL Managed Instance
  • 在 Azure 虛擬機器上執行的 SQL serverSQL server running on an Azure Virtual Machine

另請參閱See also

評估您的 SQL Server 遷移Assess your SQL Server Migration

Data Migration Assistant:設定Data Migration Assistant: Configuration settings

使用 Data Migration Assistant 遷移內部部署 SQL ServerMigrate On-Premises SQL Server using Data Migration Assistant

Data Migration Assistant:最佳做法Data Migration Assistant: Best Practices