Skip to content

Latest commit

 

History

History
65 lines (47 loc) · 3.69 KB

installing-ssma-for-oracle-client-oracletosql.md

File metadata and controls

65 lines (47 loc) · 3.69 KB
title description author ms.author ms.reviewer ms.date ms.service ms.subservice ms.topic ms.custom
Installing SSMA for Oracle client (OracleToSQL)
Learn about installation prerequisites for the SQL Server Migration Assistant (SSMA) for Oracle client and how to install.
cpichuka
cpichuka
randolphwest
07/10/2023
sql
ssma
conceptual
intro-installation
sql-migration-content

Install SSMA for Oracle client (OracleToSQL)

The SSMA client consists of the program files that perform the following tasks:

  • Connect to an Oracle database.
  • Connect to an instance of [!INCLUDE ssNoVersion].
  • Convert Oracle database objects to [!INCLUDE ssNoVersion] syntax.
  • Load the objects into [!INCLUDE ssNoVersion].
  • Migrate data to [!INCLUDE ssNoVersion].

This article provides the installation prerequisites and instructions for installing SSMA.

Prerequisites

SSMA is designed to work with Oracle 9 or later versions and all editions of [!INCLUDE ssNoVersion].

Before you install SSMA, make sure that the computer meets the following requirements:

  • Windows 7 or later versions, or Windows Server 2008 or later versions.
  • [!INCLUDE msCoName] Windows Installer 3.1 or a later version.
  • The [!INCLUDE msCoName] [!INCLUDE dnprdnshort] version 4.7.2 or a later version. You can obtain it from the .NET Framework Developer Center.
  • Connectivity to the Oracle databases that you want to migrate.
  • Access to and sufficient permissions on the computer that hosts the target instance of [!INCLUDE ssNoVersion] or [!INCLUDE ssazure-sqldb] where you are migrating database objects and data. For more information, see Connecting to SQL Server (OracleToSQL).
  • 4 GB of RAM recommended.

Install the SSMA for Oracle client

SSMA is a Web download. To download the latest version, see the SQL Server Migration Assistant download page.

To install the SSMA client:

  1. Double-click SSMAforOracle_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 appears that indicates that you must first install required components. Make sure that you have installed all prerequisites, and then run the installation program again.

  3. 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. Select Install to start the installation.

Important

Please uninstall all prior versions of SSMA for Oracle before installing the new version.

The default installation location is C:\Program Files\Microsoft SQL Server Migration Assistant for Oracle.

In addition to the SSMA program files, you must also install the SSMA for Oracle Extension Pack on [!INCLUDE ssNoVersion]. For more information, see Installing SSMA Components on SQL Server.

See also