Skip to content

working-with-ssma-projects-db2tosql.md

Latest commit

 

History

History
118 lines (70 loc) · 7.08 KB

working-with-ssma-projects-db2tosql.md

File metadata and controls

118 lines (70 loc) · 7.08 KB
title Working with SSMA Projects (DB2ToSQL) | Microsoft Docs
ms.prod sql
ms.custom
ms.date 01/19/2017
ms.reviewer
ms.technology ssma
ms.topic conceptual
ms.assetid 07abef8a-28e8-4a66-927c-c9a5b8c938ef
author Shamikg
ms.author Shamikg

Working with SSMA Projects (DB2ToSQL)

To migrate DB2 databases to [!INCLUDEssNoVersion], you first create an SSMA project. The project is a file that contains the following information:

  • Metadata about the DB2 databases you want to migrate to [!INCLUDEssNoVersion].

  • Metadata about the target instance of [!INCLUDEssNoVersion] that will receive the migrated objects and data.

  • [!INCLUDEssNoVersion] connection information.

  • Project settings.

When you open a project, it is disconnected from DB2 and [!INCLUDEssNoVersion]. That lets you work offline. For information about reconnecting to [!INCLUDEssNoVersion], see Connecting to SQL Server (DB2eToSQL).

Reviewing Default Project Settings

SSMA contains several settings for converting and loading database objects, migrating data, and synchronizing SSMA with DB2 and [!INCLUDEssNoVersion]. The default settings are appropriate for many users. However, before you create a new SSMA project, you should review the settings. If you want to, you can change the default settings that will be used for all your new projects.

To review default project settings

  1. On the Tools menu, click Default Project Settings.

  2. Select the project type in Migration Target Version drop down for which settings are required to be viewed or changed and then Click General tab.

  3. In the left pane, click Conversion.

  4. In the right pane, review and change the settings as necessary. For more information about these settings, see Project Settings (Conversion) (DB2ToSQL).

  5. Repeat Steps 1-3 for the Migration, Synchronization, Loading System Objects, GUI, and Type Mapping pages.

Creating New Projects

To migrate data from DB2 databases to [!INCLUDEssNoVersion], you must first create a project.

To create a project

  1. On the File menu, click New Project.

    The New Project dialog box appears.

  2. In the Name box, enter a name for your project.

  3. In the Location box, enter or select a folder for the project, and then click OK.

  4. In the Migration To drop down, select the version of target [!INCLUDEssNoVersion] used for migration. The options available are:

Customizing Project Settings

In addition to defining default project settings that apply to all new SSMA projects, you can customize the settings for each project. For more information, see Setting Project Options (OracleToSQL) and related sections.

When you customize data type mappings between source and target databases, you can define mappings at the project, database, or object level. For more information, see Mapping DB2 and SQL Server Data Types (DB2ToSQL).

Saving Projects

When you save a project, SSMA retains the project settings, and optionally the database metadata, to the project file.

To save a project

  • On the File menu, click Save Project.

    If schemas in the project have changed or have not been converted, SSMA will prompt you to load and save metadata. Loading and saving metadata will let you work offline. It also lets you send a complete project file to other people, such as technical support personnel. If you are prompted to save metadata, do the following:

    1. For each schema that shows a status of Metadata missing, select the check box next to the database name.

      Saving metadata might take several minutes. If you do not want to save metadata yet, do not select any check boxes.

    2. Click the Save button.

      SSMA will parse the DB2 schemas and save the metadata to the project file.

Opening Projects

When you open a project, it is disconnected from DB2 and from [!INCLUDEssNoVersion]. That lets you work offline. To update metadata, load database objects into [!INCLUDEssNoVersion]. To migrate data, you must reconnect to DB2 and [!INCLUDEssNoVersion].

To open a project

  1. Use one of the following procedures:

    • On the File menu, point to Recent Projects, and then click the project you want to open.

    • On the File menu, select Open Project, locate the .o2ssproj project file, select the file, and then click Open.

  2. To reconnect to DB2, on the File menu, click Reconnect to DB2.

  3. To reconnect to [!INCLUDEssNoVersion], on the File menu, click Reconnect to SQL Server.

Next Step

The next step in the migration process is to Connecting to DB2 Database.

See Also

Migrating DB2 Databases to SQL Server (DB2ToSQL)
Connecting to DB2 Database (DB2ToSQL)
Connecting to SQL Server (DB2eToSQL)