--- 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 [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)], 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 [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)]. - Metadata about the target instance of [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] that will receive the migrated objects and data. - [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] connection information. - Project settings. When you open a project, it is disconnected from DB2 and [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)]. That lets you work offline. For information about reconnecting to [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)], see [Connecting to SQL Server (DB2eToSQL)](../../ssma/db2/connecting-to-sql-server-db2etosql.md). ## Reviewing Default Project Settings SSMA contains several settings for converting and loading database objects, migrating data, and synchronizing SSMA with DB2 and [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)]. 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)](../../ssma/db2/project-settings-conversion-db2tosql.md). 5. Repeat Steps 1-3 for the Migration, Synchronization, Loading System Objects, GUI, and Type Mapping pages. - For information about migration settings, see [Project Settings (Migration) (DB2ToSQL)](../../ssma/db2/project-settings-migration-db2tosql.md). - For information about system object settings, see [Project Settings(Loading System objects) (DB2ToSQL)](../../ssma/db2/project-settings-loading-system-objects-db2tosql.md). - For information about settings for synchronization to [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)], see [Project Settings(Synchronization) (DB2ToSQL)](../../ssma/db2/project-settings-synchronization-db2tosql.md). - For information about GUI settings, see [Project Settings (GUI) (DB2ToSQL)](../../ssma/db2/project-settings-gui-db2tosql.md). - For information about data type mapping settings, see [Project Settings (Type Mapping) (DB2ToSQL)](../../ssma/db2/project-settings-type-mapping-db2tosql.md). ## Creating New Projects To migrate data from DB2 databases to [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)], 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 [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] used for migration. The options available are: - [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] 2012 - [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] 2014 - [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] 2016 - Azure SQL DB ## 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)](../../ssma/oracle/setting-project-options-oracletosql.md) 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)](../../ssma/db2/mapping-db2-and-sql-server-data-types-db2tosql.md). ## 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 [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)]. That lets you work offline. To update metadata, load database objects into [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)]. To migrate data, you must reconnect to DB2 and [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)]. **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 [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)], on the **File** menu, click **Reconnect to SQL Server**. ## Next Step The next step in the migration process is to [Connecting to DB2 Database](https://msdn.microsoft.com/5eb5801d-f0c3-4127-97c0-0b1ef49f4844). ## See Also [Migrating DB2 Databases to SQL Server (DB2ToSQL)](../../ssma/db2/migrating-db2-databases-to-sql-server-db2tosql.md) [Connecting to DB2 Database (DB2ToSQL)](../../ssma/db2/connecting-to-db2-database-db2tosql.md) [Connecting to SQL Server (DB2eToSQL)](../../ssma/db2/connecting-to-sql-server-db2etosql.md)