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 SQL Server 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 SQL Server or Azure SQL Database, and then migrate data to SQL Server or Azure SQL Database.

Recommended migration process

To successfully migrate objects and data from SAP ASE databases to SQL Server 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 SQL Server 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)