Migrating Sybase ASE Databases to SQL Server - Azure SQL DB (SybaseToSQL)
SQL Server Migration Assistant (SSMA) for Sybase is a comprehensive environment that helps you quickly migrate Sybase Adaptive Server Enterprise (ASE) databases to SQL Server or Azure SQL DB. By using SSMA for Sybase, you can review database objects and data, assess databases for migration, migrate database objects to SQL Server or Azure SQL DB, and then migrate data to SQL Server or Azure SQL DB.
Recommended Migration Process
To successfully migrate objects and data from ASE databases to SQL Server or Azure SQL DB, 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.
You can by either save a script and run it in SQL Server or Azure SQL DB, or you can synchronize the database objects.
If necessary, update your database applications.