Skip to content

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

Latest commit

 

History

History
55 lines (37 loc) · 2.76 KB

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

File metadata and controls

55 lines (37 loc) · 2.76 KB
title Migrate Db2 Databases to SQL Server (Db2ToSQL)
description Use this recommended process to migrate Db2 databases to SQL Server or Azure SQL Database using SQL Server Migration Assistant (SSMA).
author nilabjaball
ms.author niball
ms.reviewer randolphwest
ms.date 09/24/2024
ms.service sql
ms.subservice ssma
ms.topic upgrade-and-migration-article
ms.collection
sql-migration-content
ms.custom
intro-migration
f1_keywords
ssma.db2.migratedata.f1

Migrate Db2 Databases to SQL Server (Db2ToSQL)

SQL Server Migration Assistant (SSMA) for Db2 is a comprehensive environment that helps you quickly migrate Db2 databases to [!INCLUDE ssNoVersion] or Azure SQL Database. By using SSMA for Db2, you can review database objects and data, assess databases for migration, migrate database objects to [!INCLUDE ssNoVersion] or Azure SQL Database, and then migrate data to [!INCLUDE ssNoVersion] or Azure SQL Database. You can't migrate SYS and SYSTEM Db2 schemas.

Recommended migration process

To successfully migrate objects and data from Db2 databases to [!INCLUDE ssNoVersion] or Azure SQL Database, use the following process:

  1. New 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) and related sections. For information about how to customize data type mappings, see Map Db2 and SQL Server Data Types.

  2. Connect to Db2 database.

  3. Connect to SQL Server.

  4. Map Db2 Schemas to SQL Server Schemas.

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

  6. Convert Db2 schemas.

  7. Load converted database objects into SQL Server.

    You can do this in one of the following ways:

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

    • Synchronize the database objects.

  8. Migrate Db2 Data into SQL Server.

  9. If necessary, update database applications.

Related content