安装 SSMA for DB2 client (DB2ToSQL) Installing SSMA for DB2 client (DB2ToSQL)

SSMA 客户端由执行以下任务的程序文件组成:The SSMA client consists of the program files that perform the following tasks:

  • 连接到 DB2 数据库。Connect to a DB2 database.
  • 连接到的实例 SQL ServerSQL ServerConnect to an instance of SQL ServerSQL Server.
  • 将 DB2 数据库对象转换为 SQL ServerSQL Server 语法。Convert DB2 database objects to SQL ServerSQL Server syntax.
  • 将对象加载到中 SQL ServerSQL ServerLoad the objects into SQL ServerSQL Server.
  • 将数据迁移到 SQL ServerSQL ServerMigrate data to SQL ServerSQL Server.

本主题提供安装 SSMA 的安装先决条件和说明。This topic provides the installation prerequisites and instructions for installing SSMA.

必备条件Prerequisites

SSMA 设计用于在 z/OS 版本9.0 和10.0 上使用 db2,在 LUW 版本9.8 和10.1 或更高版本上使用 db2,适用于版本7.1 或更高版本和 SQL ServerSQL Server 2012 或更高版本的 db2。SSMA is designed to work with DB2 on z/OS version 9.0 and 10.0, DB2 on LUW version 9.8 and 10.1 or later versions, DB2 for i version 7.1 or greater and SQL ServerSQL Server 2012 or later versions.

安装 SSMA 之前,请确保计算机满足以下要求:Before you install SSMA, make sure that the computer meets the following requirements:

  • Windows 7 或更高版本,或 Windows Server 2008 或更高版本。Windows 7 or later versions, or Windows Server 2008 or later versions.
  • MicrosoftMicrosoft Windows Installer 3.1 或更高版本。Windows Installer 3.1 or later versions.
  • MicrosoftMicrosoft .NET Framework.NET Framework 版本4.7.2 或更高版本。The MicrosoftMicrosoft .NET Framework.NET Framework version 4.7.2 or a later version. 你可以从 .NET Framework 开发人员中心获取它。You can obtain it from the .NET Framework Developer Center.
  • DB2 的 Microsoft OLE DB 提供程序版本5或更高版本,以及与要迁移的 DB2 数据库的连接。Microsoft OLE DB Provider for DB2 version 5 or a later version, and connectivity to the DB2 databases that you want to migrate.
  • 对承载或 Azure SQL 数据库的目标的计算机拥有足够的权限,你将在该计算机上 SQL ServerSQL Server 迁移数据库对象和数据。Access to and sufficient permissions on the computer that hosts the target instance of SQL ServerSQL Server or Azure SQL Database where you will be migrating database objects and data. 有关详细信息,请参阅 连接到 SQL Server (DB2ToSQL)For more information, see Connecting to SQL Server (DB2ToSQL).
  • 建议使用 4 GB RAM。4 GB RAM recommended.

Microsoft OLE DB Provider for DB2Microsoft OLE DB Provider for DB2

若要下载 DB2 版本6.0 的 OLE DB 提供程序,请访问 Microsoft® SQL Server®2017功能包To download the OLE DB provider for DB2 version 6.0, go to Microsoft® SQL Server® 2017 Feature Pack.

SSMA 是一款可以从 Web 下载的工具。SSMA is a Web download. 若要下载最新版本,请参阅 SQL Server 迁移助手下载 "页To download the latest version, see the SQL Server Migration Assistant download page.

安装 SSMA 客户端:To install the SSMA client:

  1. 双击 SSMAforDB2_ " n",其中 n 是生成号。Double-click SSMAforDB2_ n.msi, where n is the build number.

  2. 在“欢迎”页上,选择“下一步”。On the Welcome page, select Next.

    如果尚未安装必备组件,则会出现一条消息,指示必须首先安装所需的组件。If you don't have the prerequisites installed, a message will appear indicating that you must first install required components. 请确保已安装所有必备组件,然后再次运行安装程序。Make sure that you've installed all prerequisites, and then run the installation program again.

  3. 阅读 End-User 许可协议。Read the End-User License Agreement. 如果同意,请选择 " 我接受协议",然后选择 " 下一步"。If you agree, select I accept the agreement, and then select Next.

  4. 在 " 选择安装类型 " 页上,选择 " 典型"。On the Choose Setup Type page, select Typical.

  5. 在 " 准备安装 " 页上,可以启用或禁用每次启动该工具时的遥测和自动更新检查。On the Ready to Install page you can enable or disable telemetry and automatic update checks every time the tool starts. 单击“安装”以开始安装。Click Install to start the installation.

重要

安装新版本之前,请卸载所有以前版本的 SSMA for DB2。Please uninstall all prior versions of SSMA for DB2 before installing the new version.

默认安装位置为 C:\Program Files\Microsoft SQL Server Migration Assistant for DB2The default installation location is C:\Program Files\Microsoft SQL Server Migration Assistant for DB2.

另请参阅See also