| title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic | ms.collection | ms.custom | ||
|---|---|---|---|---|---|---|---|---|---|---|---|
Installing SSMA for SAP ASE client (SybaseToSQL) |
Learn about installation prerequisites for SQL Server Migration Assistant (SSMA) for SAP Adaptive Server Enterprise (ASE) and how to install. |
cpichuka |
cpichuka |
07/14/2020 |
sql |
ssma |
conceptual |
|
|
The SSMA client consists of the program files that are used to connect to a SAP Adaptive Server Enterprise (ASE) database server and an instance of [!INCLUDEssNoVersion] or [!INCLUDE ssazure-sqldb], convert ASE database objects to [!INCLUDEssNoVersion] or [!INCLUDE ssazure-sqldb] syntax, load the objects into [!INCLUDEssNoVersion] or [!INCLUDE ssazure-sqldb], and then migrate data to [!INCLUDEssNoVersion] or [!INCLUDE ssazure-sqldb].
This topic provides the installation prerequisites and instructions for installing SSMA.
SSMA is designed to work with SAP ASE 11.9.2 or later versions and all editions of [!INCLUDEssNoVersion].
Before you install SSMA, make sure that the computer meets the following requirements:
- Windows 7 or later versions, or Windows Server 2008 or later versions.
- [!INCLUDEmsCoName] Windows Installer 3.1 or a later version.
- The [!INCLUDEmsCoName] .NET Framework version 4.7.2 or a later version. You can obtain it from the .NET Framework Developer Center.
- 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 (SybaseToSQL).
- Access to and sufficient permissions on the computer that hosts the target instance of [!INCLUDEssNoVersion] or [!INCLUDE ssazure-sqldb] where you will be migrating database objects and data. For more information, see Connecting to SQL Server (SybaseToSQL)/Connecting to Azure SQL Database (SybaseToSQL).
- 4 GB RAM recommended.
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, click Next.
If you do not have the prerequisites installed, a message will appear 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 click Next.
-
On the Choose Setup Type page, click Typical.
-
On the Ready to Install page you can enable or disable telemetry and automatic update checks every time the tool starts. Click Install to start the installation.
Important
Please 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 [!INCLUDEssNoVersion]. For more information, see Installing SSMA Components on SQL Server (SybaseToSQL).