Skip to content

migrating-sybase-ase-databases-to-sql-server-azure-sql-db-sybasetosql.md

Latest commit

 

History

History
56 lines (42 loc) · 3.54 KB

migrating-sybase-ase-databases-to-sql-server-azure-sql-db-sybasetosql.md

File metadata and controls

56 lines (42 loc) · 3.54 KB
title Migrate Sybase ASE Databases to SQL Server - Azure SQL DB | Microsoft Docs
ms.custom
ms.date 11/30/2017
ms.prod sql-non-specified
ms.prod_service sql-non-specified
ms.service
ms.component ssma-sybase
ms.reviewer
ms.suite sql
ms.technology
sql-ssma
ms.tgt_pltfrm
ms.topic article
applies_to
Azure SQL Database
SQL Server
ms.assetid ed7952d4-8331-44d7-bccf-3440e17238b2
caps.latest.revision 7
author Shamikg
ms.author Shamikg
manager jhubbard
ms.workload Inactive

Migrating SAP ASE databases to SQL Server - Azure SQL Database (SybaseToSQL)

SQL Server Migration Assistant (SSMA) for SAP Adaptive Server Enterprise (ASE) is a comprehensive environment that helps you quickly migrate SAP ASE databases to [!INCLUDEssNoVersion] or Azure SQL Database. By using SSMA for SAP ASE, you can review database objects and data, assess databases for migration, migrate database objects to [!INCLUDEssNoVersion] or Azure SQL Database, and then migrate data to [!INCLUDEssNoVersion] or Azure SQL Database.

Recommended migration process

To successfully migrate objects and data from SAP ASE databases to [!INCLUDEssNoVersion] or Azure SQL Database, use the following process:

  1. Create a new SSMA project.

    After you create the project, you can set project conversion, migration, and type mapping options. For information about project settings, see Setting Project Options (SybaseToSQL). For information about customizing data type mappings, see Mapping Sybase ASE and SQL Server Data Types (SybaseToSQL).

  2. Connect to the SAP ASE database server.

  3. Connect to an instance SQL Server or Connect to an instance of Azure SQL Database.

  4. Map SAP ASE database schemas to SQL Server / Azure SQL Database database schemas.

  5. Optionally, create assessment reports to assess database objects for conversion and estimate the conversion time.

  6. Convert SAP ASE database schemas into SQL Server / Azure SQL Database schemas.

  7. Load the converted database objects into SQL Server / Azure SQL Database.

    Either save a script and run it in [!INCLUDEssNoVersion] or Azure SQL Database, or synchronize the database objects.

  8. Migrate data to SQL Server / Azure SQL Database.

  9. If necessary, update your database applications.

See also

Installing SSMA for SAP ASE (SybaseToSQL)
Getting Started with SSMA for SAP ASE (SybaseToSQL)