| title | description | author | ms.author | ms.reviewer | ms.date | ms.service | ms.subservice | ms.topic | ms.collection | ms.custom | ||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
Get started with SSMA for Db2 (Db2ToSQL) |
Learn how SSMA for Db2 quickly converts Db2 database schemas to SQL Server schemas, and migrates data. |
cpichuka |
cpichuka |
randolphwest |
09/24/2024 |
sql |
ssma |
get-started |
|
|
SQL Server Migration Assistant (SSMA) for Db2 lets you quickly convert Db2 database schemas to [!INCLUDE ssNoVersion] schemas, upload the resulting schemas into [!INCLUDE ssNoVersion] and migrate data from Db2 to [!INCLUDE ssNoVersion].
This article introduces the installation process, and then helps familiarize you with the SSMA user interface.
To use SSMA, you first must install the SSMA client program on a computer that can access both the source Db2 database and the target instance of [!INCLUDE ssNoVersion]. Db2 OLEDB providers on the computer that is running [!INCLUDE ssNoVersion]. These components support data migration and the emulation of Db2 system functions. For installation instructions, see Install SSMA for Db2.
To start SSMA, open the Start menu and navigate to All Programs > SQL Server Migration Assistant for Db2, and then select SQL Server Migration Assistant for Db2.
After SSMA is installed, you can use SSMA to migrate Db2 databases to [!INCLUDE ssNoVersion]. It helps to become familiar with the SSMA user interface before you start. The following diagram shows the user interface for SSMA, including the metadata explorers, metadata, toolbars, output pane, and error list pane:
:::image type="content" source="media/ssma_db2_ui.png" alt-text="Screenshot of SSMA User Interface." lightbox="media/ssma_db2_ui.png":::
To start a migration, you must first create a new project. Then, you connect to an Db2 database. After a successful connection, Db2 schemas will appear in Db2 Metadata Explorer. You can then right-click objects in Db2 Metadata Explorer to perform tasks such as create reports that assess conversions to [!INCLUDE ssNoVersion]. You can also perform these tasks by using the toolbars and menus.
You must also connect to an instance of [!INCLUDE ssNoVersion]. After a successful connection, a hierarchy of [!INCLUDE ssNoVersion] databases will appear in [!INCLUDE ssNoVersion] Metadata Explorer. After you convert Db2 schemas to [!INCLUDE ssNoVersion] schemas, select those converted schemas in [!INCLUDE ssNoVersion] Metadata Explorer, and then synchronize the schemas with [!INCLUDE ssNoVersion].
After you synchronize converted schemas with [!INCLUDE ssNoVersion], you can return to Db2 Metadata Explorer and migrate data from Db2 schemas into [!INCLUDE ssNoVersion] databases.
For more information about these tasks and how to perform them, see Migrate Db2 Databases to SQL Server.
The following sections describe the features of the SSMA user interface.
SSMA contains two metadata explorers to browse and perform actions on Db2 and [!INCLUDE ssNoVersion] databases.
Db2 Metadata Explorer shows information about Db2 schemas. By using Db2 Metadata Explorer, you can perform the following tasks:
-
Browse the objects in each schema.
-
Select objects for conversion, and then convert the objects to [!INCLUDE ssNoVersion] syntax. For more information, see Convert Db2 schemas.
-
Select tables for data migration, and then migrate the data from those tables to [!INCLUDE ssNoVersion]. For more information, see Migrate Db2 Databases to SQL Server.
[!INCLUDE ssNoVersion] Metadata Explorer shows information about an instance of [!INCLUDE ssNoVersion]. When you connect to an instance of [!INCLUDE ssNoVersion], SSMA retrieves metadata about that instance and stores it in the project file.
You can use [!INCLUDE ssNoVersion] Metadata Explorer to select converted Db2 database objects, and then synchronize those objects with the instance of [!INCLUDE ssNoVersion].
To the right of each metadata explorer are tabs that describe the selected object. For example, if you select a table in Db2 Metadata Explorer, six tabs appear: Table, SQL, Type Mapping,Report, Properties, and Data. The Report tab contains information only after you create a report that contains the selected object. If you select a table in [!INCLUDE ssNoVersion] Metadata Explorer, three tabs appear: Table, SQL, and Data.
Most metadata settings are read-only. However, you can alter the following metadata:
-
In Db2 Metadata Explorer, you can alter procedures and type mappings. To convert the altered procedures and type mappings, make changes before you convert schemas.
-
In [!INCLUDE ssNoVersion] Metadata Explorer, you can alter the [!INCLUDE tsql] for stored procedures. To see these changes in [!INCLUDE ssNoVersion], make these changes before you load the schemas into [!INCLUDE ssNoVersion].
Changes made in a metadata explorer are reflected in the project metadata, not in the source or target databases.
SSMA has two toolbars: a project toolbar and a migration toolbar.
The project toolbar contains buttons for working with projects, connecting to Db2, and connecting to [!INCLUDE ssNoVersion]. These buttons resemble the commands on the File menu.
The following table shows the migration toolbar commands:
| Button | Function |
|---|---|
| Create Report | Converts the selected Db2 objects to [!INCLUDE ssNoVersion] syntax, and then creates a report that shows how successful the conversion was. This command is disabled unless objects are selected in Db2 Metadata Explorer. |
| Convert Schema | Converts the selected Db2 objects to [!INCLUDE ssNoVersion] objects. This command is disabled unless objects are selected in Db2 Metadata Explorer. |
| Migrate Data | Migrates data from the Db2 database to [!INCLUDE ssNoVersion]. Before you run this command, you must convert the Db2 schemas to [!INCLUDE ssNoVersion] schemas, and then load the objects into [!INCLUDE ssNoVersion]. This command is disabled unless objects are selected in Db2 Metadata Explorer. |
| Stop | Stops the current process. |
The following table shows the SSMA menus.
| Menu | Description |
|---|---|
| File | Contains commands for working with projects, connecting to Db2, and connecting to [!INCLUDE ssNoVersion]. |
| Edit | Contains commands for finding and working with text in the details pages, such as copying [!INCLUDE tsql] from the SQL details pane. Also contains the Manage Bookmarks option, where you're able to see a list of existing bookmarks. You can use the buttons on the right side of the dialog to manage the bookmarks. |
| View | Contains the Synchronize Metadata Explorers command. That synchronizes the objects between Db2 Metadata Explorer and [!INCLUDE ssNoVersion] Metadata Explorer. Also contains commands to show and hide the Output and Error List panes and an option Layouts to manage the Layouts. |
| Tools | Contains commands to create reports, and migrate objects and data. Also provides access to the Global Settings and Project Settings dialog boxes. |
| Help | Provides access to SSMA Help and to the About dialog box. |
The View menu provides commands to toggle the visibility of the Output pane and the Error List pane:
-
The output pane shows status messages from SSMA during object conversion, object synchronization, and data migration.
-
The Error List pane shows error, warning, and informational messages in a sortable list.