Skip to content

Latest commit

 

History

History
76 lines (51 loc) · 4.17 KB

installing-ssma-for-db2-client-db2tosql.md

File metadata and controls

76 lines (51 loc) · 4.17 KB
title description author ms.author ms.reviewer ms.date ms.service ms.subservice ms.topic ms.collection ms.custom
Install SSMA for Db2 client (Db2ToSQL)
Learn about installation prerequisites for the SQL Server Migration Assistant (SSMA) for Db2 client and how to install.
cpichuka
cpichuka
randolphwest
09/24/2024
sql
ssma
install-set-up-deploy
sql-migration-content
intro-installation

Install SSMA for Db2 client (Db2ToSQL)

The SQL Server Migration Assistant (SSMA) client consists of the program files that perform the following tasks:

  • Connect to a Db2 database.
  • Connect to an instance of [!INCLUDE ssNoVersion].
  • Convert Db2 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 Db2 on z/OS version 9.0, 10.0, and later versions, Db2 on LUW version 9.8, 10.1, and later versions, Db2 for i version 7.1 and later versions, and [!INCLUDE sssql11-md] and later versions.

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.
  • Windows Installer 3.1 or later versions.
  • The [!INCLUDE dnprdnshort] version 4.7.2 or a later version. You can obtain it from the .NET Framework Developer Center.
  • Microsoft OLE DB Provider for Db2 version 5 or a later version, and connectivity to the Db2 databases that you want to migrate.
  • Access to and sufficient permissions on the computer that hosts the target instance of [!INCLUDE ssNoVersion] or Azure SQL Database where you're migrating database objects and data. For more information, see Connect to SQL Server.
  • 4 GB of RAM is recommended.

SSMA for Db2 Extension Pack

In this version of SSMA, you don't need a separate install on [!INCLUDE ssNoVersion] of the SSMA extension pack, which supports data migration, and Db2 providers to enable server-to-server connectivity.

The SSMA extension pack adds a schema the database in the specified instance of [!INCLUDE ssNoVersion]. The sysdb schema contains the tables and stored procedures that are required to migrate data, and the user-defined functions that emulate Db2 system functions.

Microsoft OLE DB Provider for Db2

To download the OLE DB provider for Db2 version 6.0, go to Microsoft SQL Server 2017 Feature Pack.

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 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 appears indicating that you must first install required components. Make sure that you 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 Db2 before installing the new version.

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

Related content