Skip to content

working-with-ssma-projects-oracletosql.md

Latest commit

 

History

History
125 lines (77 loc) · 6.9 KB

working-with-ssma-projects-oracletosql.md

File metadata and controls

125 lines (77 loc) · 6.9 KB
title Working with SSMA Projects (OracleToSQL)
description Learn how to create an SSMA project that contains metadata for Oracle databases to migrate and SQL Server, along with settings and connection information.
author nilabjaball
ms.author niball
ms.reviewer randolphwest
ms.date 11/12/2025
ms.service sql
ms.subservice ssma
ms.topic how-to
ms.collection
sql-migration-content
f1_keywords
ssma.oracle.workplacedialog.f1
helpviewer_keywords
Customizing Project Settings

Work with SSMA Projects (OracleToSQL)

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

  • Metadata about the Oracle databases you want to migrate to [!INCLUDE ssNoVersion].
  • Metadata about the target instance of [!INCLUDE ssNoVersion] that receive the migrated objects and data.
  • [!INCLUDE ssNoVersion] connection information.
  • Project settings.

When you open a project, it's disconnected from Oracle and [!INCLUDE ssNoVersion]. That lets you work offline. For information about reconnecting to [!INCLUDE ssNoVersion], see Connecting to SQL Server (OracleToSQL).

Review default project settings

SSMA contains several settings for converting and loading database objects, migrating data, and synchronizing SSMA with Oracle and [!INCLUDE ssNoVersion]. 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.

Review default project settings

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

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

  3. In the left pane, select Conversion.

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

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

Create new projects

To migrate data from Oracle databases to [!INCLUDE ssNoVersion], you must first create a project.

Create a project

  1. On the File menu, select 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 select OK.

  4. In the Migration To dropdown list, select the version of target [!INCLUDE ssNoVersion] used for migration. The options available are:

And then select OK.

Customize 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 Set project options (OracleToSQL).

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 Map Oracle and SQL Server data types (OracleToSQL).

Save projects

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

Save a project

  • On the File menu, select Save Project.

    If schemas in the project have changed or haven't been converted, SSMA prompts you to load and save metadata. Loading and saving metadata lets you work offline. It also lets you send a complete project file to other people, such as technical support personnel. If you're 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 don't want to save metadata yet, don't select any check boxes.

    2. Select the Save button.

      SSMA parses the Oracle schemas and saves the metadata to the project file.

Open projects

When you open a project, it's disconnected from Oracle and from [!INCLUDE ssNoVersion]. That lets you work offline. To update metadata, load database objects into [!INCLUDE ssNoVersion]. To migrate data, you must reconnect to Oracle and [!INCLUDE ssNoVersion].

Open a project

  1. Use one of the following procedures:

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

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

  2. To reconnect to Oracle, on the File menu, select Reconnect to Oracle.

  3. To reconnect to [!INCLUDE ssNoVersion], on the File menu, select Reconnect to SQL Server.

Related content