migrating-db2-databases-to-sql-server-db2tosql.md

title	Migrating DB2 Databases to SQL Server (DB2ToSQL) | Microsoft Docs
ms.prod	sql
ms.custom
ms.date	01/19/2017
ms.reviewer
ms.technology	ssma
ms.topic	conceptual
ms.assetid	14d2e655-af7e-4aa5-ba28-0e3d0d025518
author	Shamikg
ms.author	Shamikg

Migrating DB2 Databases to SQL Server (DB2ToSQL)

[!INCLUDEssNoVersion] Migration Assistant (SSMA) for DB2 is a comprehensive environment that helps you quickly migrate DB2 databases to [!INCLUDEssNoVersion] or Azure SQL DB. By using SSMA for DB2, you can review database objects and data, assess databases for migration, migrate database objects to [!INCLUDEssNoVersion] or Azure SQL DB, and then migrate data to [!INCLUDEssNoVersion] or Azure SQL DB. Note that you cannot migrate SYS and SYSTEM DB2 schemas.

Recommended Migration Process

To successfully migrate objects and data from DB2 databases to [!INCLUDEssNoVersion] or Azure SQL DB, use the following process:

1. New SSMA project.

   After you create the project, you can set project conversion, migration, and type mapping options. For information about project settings, see Project Settings (Conversion) (DB2ToSQL) and related sections. For information about how to customize data type mappings, see Mapping DB2 and SQL Server Data Types (DB2ToSQL).

2. Connect to the DB2 database.

3. Connecting to SQL Server.

4. Map DB2 schemas to SQL Server schemas.

5. Optionally, Assessment reports to assess database objects for conversion and estimate the conversion time.

6. Convert DB2 schemas.

7. Load the converted database objects into SQL Server.

   You can do this in one of the following ways:

   • Save a script and run it in [!INCLUDEssNoVersion].

   • Synchronize the database objects.

8. Migrating DB2 Data into SQL Server.

9. If necessary, update database applications.

See Also

Installing SSMA for DB2 (DB2ToSQL)
Getting Started with SSMA for DB2 (DB2ToSQL)