SQL Server Migration Assistant for DB2 (DB2ToSQL)

SQL Server Migration Assistant (SSMA) for DB2 is a tool for migrating DB2 databases to:

  • SQL Server 2012 (11.x)
  • SQL Server 2014 (12.x)
  • SQL Server 2016 (13.x)
  • SQL Server 2017 (14.x) (on Windows and Linux)
  • SQL Server 2019 (15.x) (on Windows and Linux)
  • SQL Server 2022 (16.x) (on Windows and Linux)
  • Azure SQL Database

SSMA for DB2 converts DB2 database objects to SQL Server database objects, creates those objects in SQL Server, and then migrates data from DB2 to SQL Server or Azure SQL Database.

This documentation introduces you to SSMA for DB2 and provides step-by-step instructions for migrating DB2 databases to SQL Server. The following table shows articles to help you learn more:


Section Description
What's New in SSMA for DB2 What is new in this version of SSMA for DB2
Installing SSMA for DB2 Client (DB2ToSQL) Contains articles that provide prerequisites and instructions for installing the SSMA for DB2 client and required components on the computer that is running SQL Server.
Getting Started with SSMA for DB2 (DB2ToSQL) Introduces the user interface, projects, and configuration options.
Migrating DB2 Databases to SQL Server (DB2ToSQL) Provides an overview of the conversion process and detailed information about each step in the process.
User Interface Reference (DB2ToSQL) Contains documentation for SSMA for DB2 dialog boxes.
Working with SSMA for DB2 Console Contains documentation on the SSMA Console application
Getting SSMA for DB2 Assistance Provides information about getting additional assistance.