Migrating Sybase ASE Databases to SQL Server/ SQL Azure (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 SQL Azure. By using SSMA for Sybase, you can review database objects and data, assess databases for migration, migrate database objects to SQL Server or SQL Azure, and then migrate data to SQL Server or SQL Azure.
To successfully migrate objects and data from ASE databases to SQL Server or SQL Azure, 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 SQL Azure, or you can synchronize the database objects.
If necessary, update your database applications.