Microsoft SQL Server Migration Assistant for SAP Adaptive Server Enterprise (formerly SAP Sybase ASE).

SQL Server Migration Assistant (SSMA) is a free supported tool from Microsoft that simplifies database migration process from SAP Adaptive Server Enterprise (formerly SAP Sybase ASE) to SQL Server, Azure SQL Database and Azure SQL Database Managed Instance. SSMA automates all aspects of migration including migration assessment analysis, schema and SQL statement conversion, data migration as well as migration testing.

This download includes a GUI client based application to manage migration process. A seperate extension pack will install functionalities in SQL Server to emulate SAP ASE features not natively supported in SQL Server.

SSMA for SAP ASE is designed to support migration from SAP ASE version 11.9 and higher to all editions of SQL Server 2016 onwards, Azure SQL Database and Azure SQL Database Managed Instance.

Supported Operating Systems

Windows Server 2016, Windows 10, Windows Server 2012 R2, Windows Server 2008 R2, Windows Server 2012, Windows 7, Windows 8, Windows 8.1

• Windows 10+, Windows Server 2016+

Requirements for the SSMA for SAP ASE client:

• The Microsoft .NET Framework version 4.7.2 or a later version. You can obtain it from the .NET Framework Developer Center.
• The SAP ASE OLEDB/ADO.Net/ODBC provider and connectivity to the SAP ASE database server that contains the databases you want to migrate. You can install providers from the SAP ASE product media.
• Access to and sufficient permissions on the computer that hosts the target instance of SQL Server.
• 4 GB RAM.

After the download, you must install SSMA for SAP ASE.

Installing the SSMA for SAP ASE Client

1. Double-click SSMAforSybase_n.msi, where n is the version number.
2. On the 'Welcome' page, click Next.
3. If you do not have the prerequisite SAP ASE OLE DB provider installed, a message will appear indicating that you must first install the providers. You can install the SAP ASE OLE DB provider from the SAP ASE product media.
4. Read the End User License Agreement. If you agree to the terms, select "I accept the agreement" option and click Next.
5. On the 'Choose Setup Type' page, click Typical.
6. Click Install.

In addition to the SSMA program files, you must also install the SSMA for SAP ASE Extension Pack on the SQL Server machine.

Installing the SSMA for SAP ASE Extension Pack
Installing the extension pack creates a new database, sysdb, on the instance of SQL Server. The extension pack adds tables, stored procedures, and user-defined functions.

1. Double-click SSMA for SSMAforSybaseExtensionPack_n.msi file, where n is the version number.
2. On the 'Welcome' page, click Next.
3. Read the End User License Agreement. If you agree to the terms, select "I accept the agreement" option and click Next.
4. On the 'Ready to Install' page, click Install.
5. On the 'Completed the First Step of Installation' page, click Next. A new dialog box will appear, in which you select the instance of SQL Server for the extension pack installation.
6. Select the instance of SQL Server where you will be migrating SAP ASE schemas, and then click Next. The default instance has the same name as the computer. Named instances will be followed by a backslash and the instance name.
7. On the connection page, select the authentication method and then click Next. Windows Authentication will use your Windows credentials to try to log on to the instance of SQL Server. If you select SQL Server Authentication, you must enter a SQL Server login name and password.
8. On the next page, select Install Utilities Database n, where n is the version number, and then click Next. The sysdb database is created and the user-defined functions and stored procedures are created in that database.
9. To install the utilities to another instance of SQL Server, select Yes, and then click Next. Or, to exit the wizard, click No.

NOTE: Extension pack and its functionality is not supported for SQL Server on Linux, Azure SQL Database and Azure SQL Database Managed Instance.