ssma5.3_适用于Oracle的Microsoft SQL Server迁移助手（SSMA）v7.1

ssma5.3

介绍 (Introduction)

SQL Server Migration Assistant (SSMA) is a free supported tool from Microsoft that simplifies and automates database migration processes (assessment analysis, necessary conversions, data migration and tests) from Microsoft Access, MySQL, Oracle, Sybase and DB2 to SQL Server, Azure SQL DB and SQL Server vNext (at the time I’m writing this article, SQL Server vNext stills in CTP1 version, so being a technical preview version it should not be used for production migrations).

SQL Server迁移助手（SSMA）是Microsoft免费支持的工具，可简化和自动化从Microsoft Access，MySQL，Oracle，Sybase和DB2到SQL Server，Azure SQL的数据库迁移过程（评估分析，必要的转换，数据迁移和测试）。 DB和SQL Server vNext（在撰写本文时，SQL Server vNext仍为CTP1版本，因此，作为技术预览版，不应将其用于生产迁移）。

In this article I will focus only on SSMA v7.1 for Oracle that converts Oracle database objects to SQL Server database objects by creating those objects in SQL Server and then migrates the data from Oracle to SQL Server.

在本文中，我将仅针对Oracle的SSMA v7.1，该方法通过在SQL Server中创建对象将Oracle数据库对象转换为SQL Server数据库对象，然后将数据从Oracle迁移到SQL Server。

SSMA v7.1 for Oracle is designed to support migration from Oracle 9.07.3 or later version to all edition of SQL Server 2008, SQL Server 2008 R2, and SQL Server 2012, SQL Server 2014, SQL Server 2016 and Azure SQL DB and SQL Server vNext CTP1.

适用于Oracle的SSMA v7.1旨在支持从Oracle 9.07.3或更高版本迁移到所有版本SQL Server 2008，SQL Server 2008 R2和SQL Server 2012，SQL Server 2014，SQL Server 2016以及Azure SQL DB和SQL服务器vNext CTP1。

SSMA for Oracle consists of a GUI client application, which must be installed on the computer from which you will perform the migration steps. That GUI is used to manage and perform the migration process from Oracle to SQL Server, Azure SQL DB and SQL Server vNext CTP1.

SSMA for Oracle由GUI客户端应用程序组成，必须将其安装在要从中执行迁移步骤的计算机上。 该GUI用于管理和执行从Oracle到SQL Server，Azure SQL DB和SQL Server vNext CTP1的迁移过程。

It also contains an extension pack to be installed on the target SQL Server machine. SSMA extension pack includes functionalities that support Oracle data migration and emulates Oracle features not natively supported in SQL server, a tester database to support SSMA Testing features and an application to facilitate direct server-to-server data migration.

它还包含要在目标SQL Server计算机上安装的扩展包。 SSMA扩展包包括支持Oracle数据迁移并模拟SQL Server本身不支持的Oracle功能的功能，支持SSMA Testing功能的测试器数据库以及促进直接从服务器到服务器的数据迁移的应用程序。

Let see now how to install SSMA v7.1 for Oracle necessary for migrating to a SQL Server instance. The below instructions may differ for Azure SQL DB and SQL Server vNext since they are not in the scope of this article.

现在让我们看看如何为迁移到SQL Server实例安装必需的Oracle SSMA v7.1。 以下说明对于Azure SQL DB和SQL Server vNext可能有所不同，因为它们不在本文的范围之内。

As referred previously, SSMA v7.1 for Oracle consists of two packages, the SSMA for Oracle Client and the SSMA for Oracle Extension Pack. Both can be installed in the target SQL Server machine or have SSMA for Oracle Extension Pack installed in the target server and SSMA for Oracle Client installed in any other machine. I will let the system requirements for separated computers and in case of installation in a single server you will need to merge both requirements to assure that the installation won’t fail.

如前所述，适用于Oracle的SSMA v7.1由两个软件包组成，即适用于Oracle Client的SSMA和适用于Oracle Extension Pack的SSMA。 两者都可以安装在目标SQL Server计算机上，也可以在目标服务器上安装SSMA for Oracle Extension Pack，在其他任何计算机上安装SSMA for Oracle Client。 我将使用分开的计算机的系统要求，如果要在单个服务器中进行安装，则需要合并这两个要求，以确保安装不会失败。

系统要求 (System Requirements)

Oracle客户端对SSMA的要求： (Requirements for the SSMA for Oracle client: )

• Windows 7 or superior, Windows Server 2008R2 or superior
  Windows 7或更高版本，Windows Server 2008R2或更高版本
• Microsoft Windows Installer 3.1 or a later version.
  Microsoft Windows Installer 3.1或更高版本。
• The Microsoft .NET Framework version 4.0 or a later version.
  Microsoft .NET Framework 4.0版或更高版本。
• Oracle Client 9.0 or a later version, and connectivity to the Oracle databases that you want to migrate. The Oracle client version must be the same version as, or a later version than, the Oracle database version.
  Oracle Client 9.0或更高版本，以及与要迁移的Oracle数据库的连接。 Oracle客户端版本必须与Oracle数据库版本相同或更高。
• Access to and sufficient permissions on the computer that hosts the target instance of SQL Server.
  对承载SQL Server目标实例的计算机具有足够的访问权限。
• 4 GB RAM.
  4 GB RAM。

SSMA for Oracle Extension Pack的要求： (Requirements for the SSMA for Oracle Extension Pack: )

• Windows 7 or superior, Windows Server 2008R2 or superior
  Windows 7或更高版本，Windows Server 2008R2或更高版本
• SQL Server 2008 or higher (it does not support Express Edition).
  SQL Server 2008或更高版本（不支持Express Edition）。
• Microsoft Windows Installer 3.1 or a later version.
  Microsoft Windows Installer 3.1或更高版本。
• Oracle Client 9.0 or a later version, and connectivity to the Oracle databases that you want to migrate. The Oracle client version must be the same version as, or a later version than, the Oracle database version.
  Oracle Client 9.0或更高版本，以及与