--- title: "Working with SSMA Projects (SybaseToSQL) | Microsoft Docs" ms.custom: "" ms.date: "01/19/2017" ms.prod: sql ms.reviewer: "" ms.technology: ssma ms.topic: conceptual ms.assetid: 11091d95-c488-48c3-891a-743cac94ac93 author: "Shamikg" ms.author: "Shamikg" --- # Working with SSMA Projects (SybaseToSQL) To migrate Sybase Adaptive Server Enterprise (ASE) databases to [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] or SQL Azure, you first create an SSMA project. The project is a file that contains metadata about the ASE databases that you want to migrate to [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] or SQL Azure, metadata about the target instance of [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] or SQL Azure that will receive the migrated objects and data, [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] or SQL Azure connection information, and project settings. When you open a project, it is disconnected from [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] or SQL Azure. This lets you work offline. You can reconnect to [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] or SQL Azure. For more information, see [Connecting to SQL Server (SybaseToSQL)](../../ssma/sybase/connecting-to-sql-server-sybasetosql.md) / [Connecting to Azure SQL DB (SybaseToSQL)](../../ssma/sybase/connecting-to-azure-sql-db-sybasetosql.md). ## Reviewing Default Project Settings SSMA contains several options for converting and loading database objects, migrating data, and synchronizing SSMA with ASE and [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] or SQL Azure. The default settings for these options are appropriate for many users. However, before you create a new SSMA project, you should review the options and, if you want to, change the defaults that will be used for all your new projects. **To review default project settings** 1. On the **Tools** menu, select **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 the options, changing options as necessary. For more information about these options, see [Project Settings (Conversion) (SybaseToSQL)](../../ssma/sybase/project-settings-conversion-sybasetosql.md). 5. Repeat steps 1-3 for the Migration, SQL Azure, Loading Objects, GUI, and Type Mapping pages. - For information about migration options, see [Project Settings (Migration) (SybaseToSQL)](../../ssma/sybase/project-settings-migration-sybasetosql.md). - For information about options for loading objects into [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)], see [Project Settings (Synchronization) (SybaseToSQL)](../../ssma/sybase/project-settings-synchronization-sybasetosql.md). - For more information about GUI options, see [Project Settings (GUI) (SybaseToSQL)](../../ssma/sybase/project-settings-gui-sybasetosql.md). - For more information about data type mapping settings, click [Project Settings (Type Mapping) (SybaseToSQL)](../../ssma/sybase/project-settings-type-mapping-sybasetosql.md). - For more information about SQL Azure options, see [Project Settings (Azure SQL DB ) (SybaseToSQL)](../../ssma/sybase/project-settings-azure-sql-db-sybasetosql.md). > [!NOTE] > The SQL Azure settings will be displayed only when you select **Migration to SQL Azure** while creating a project. ## Creating New Projects To migrate data from ASE databases to [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] or SQL Azure, you must first create a project. **To 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. 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)] 2005 - [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] 2008 - [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] 2012 - [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] 2014 - [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] 2016 - Azure SQL DB And then Click **OK**. ## 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 (SybaseToSQL)](../../ssma/sybase/setting-project-options-sybasetosql.md). 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 about type mapping, see [Mapping Sybase ASE and SQL Server Data Types (SybaseToSQL)](../../ssma/sybase/mapping-sybase-ase-and-sql-server-data-types-sybasetosql.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, select **Save Project**. If databases within the project have changed or have not been converted, SSMA will prompt you to save metadata into the project. Saving metadata will let you work offline and to send a complete project file to other people, including technical support personnel. If you are prompted to save metadata, do the following: 1. For each database 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 at this point, do not select any check boxes. 2. Click the **Save** button. SSMA will parse the Sybase ASE schemas and save the metadata to the project file. ## Opening Projects When you open a project, it is disconnected from ASE and from [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] or SQL Azure. This lets you work offline. To update metadata, load database objects into [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] or SQL Azure. To migrate data, you must reconnect to ASE and [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] or SQL Azure. **To 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 .s2ssproj project file, select the file, and then click **Open**. 2. To reconnect to ASE, on the **File** menu, select **Reconnect to Sybase**. 3. To reconnect to [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] or SQL Azure, on the **File** menu, select **Reconnect to SQL Server** / **Reconnect to SQL Azure**. ## Next Step The next step in the migration process is to [Connect to Sybase ASE](connecting-to-sybase-ase-sybasetosql.md). ## See Also [Migrating Sybase ASE Databases to SQL Server - Azure SQL DB (SybaseToSQL)](../../ssma/sybase/migrating-sybase-ase-databases-to-sql-server-azure-sql-db-sybasetosql.md) [Connecting to Sybase ASE (SybaseToSQL)](../../ssma/sybase/connecting-to-sybase-ase-sybasetosql.md) [Connecting to SQL Server (SybaseToSQL)](../../ssma/sybase/connecting-to-sql-server-sybasetosql.md) [Connecting to Azure SQL DB (SybaseToSQL)](../../ssma/sybase/connecting-to-azure-sql-db-sybasetosql.md)