Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
The SQL Server Migration Assistant (SSMA) client migrates SAP Adaptive Server Enterprise (ASE) databases. Supported target versions include SQL Server 2019 (15.x) and later versions on Windows and Linux, Azure SQL Database, and Azure SQL Managed Instance. The client:
- Connects to the ASE source and the SQL Server Database Engine target.
- Converts database objects for the target.
- Loads the converted objects into the target.
- Migrates the data.
This article provides the installation prerequisites and instructions for installing SSMA.
Prerequisites
SSMA is designed to work with SAP ASE 16.0 and later versions.
Before you install SSMA, make sure that the computer meets the following requirements:
- Windows 11 or later versions, or Windows Server 2022 or later versions.
- The .NET Framework version 4.7.2 or a later version. Download .NET Framework.
- The Sybase OLE DB/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. For information about connectivity, see Connecting to Sybase ASE.
- Access to and sufficient permissions on the computer that hosts the target instance of SQL Server or Azure SQL Database where you're migrating database objects and data. For more information, see Connecting to SQL Server/Connecting to Azure SQL Database.
- 4 GB RAM recommended.
Install the SSMA for Sybase client
SSMA is a Web download. To download the latest version, see the SQL Server Migration Assistant download page.
To install the SSMA client:
Double-click SSMAforSybase_n.msi, where n is the build number.
On the Welcome page, select Next.
If you don't have the prerequisites installed, a message appears that indicates that you must first install required components. Make sure that you have installed all prerequisites, and then run the installation program again.
Read the End-User License Agreement. If you agree, select I accept the agreement, and then select Next.
On the Choose Setup Type page, select Typical.
On the Ready to Install page you can enable or disable telemetry and automatic update checks every time the tool starts. Select Install to start the installation.
Important
Uninstall all prior versions of SSMA for Sybase before installing the new version.
The default installation location is C:\Program Files\Microsoft SQL Server Migration Assistant for Sybase.
In addition to the SSMA program files, you must also install the SSMA for Sybase Extension Pack on SQL Server. For more information, see Installing SSMA Components on SQL Server.