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:
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).
Optionally, create assessment reports to assess database objects for conversion and estimate the conversion time.
Either save a script and run it in SQL Server or Azure SQL Database, or synchronize the database objects.
If necessary, update your database applications.