Servers

    Microsoft SQL Server Migration Assistant v6.0 for Sybase

    Language:
    English
    Microsoft SQL Server Migration Assistant (SSMA) for Sybase is a tool to automate migration from Sybase ASE
    • Note:There are multiple files available for this download.Once you click on the "Download" button, you will be prompted to select the files you need.
      Version:

      6.0

      File Name:

      SSMA for Sybase.6.0.0.exe

      SSMA for Sybase.6.0.0.ExtPack.exe

      Date Published:

      10/28/2014

      File Size:

      8.5 MB

      2.7 MB

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

        SSMA for Sybase v6.0 is designed to support migration from Sybase ASE version 11.9 and higher to all editions of SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012, SQL Server 2014 and Azure SQL DB.
    • Supported Operating System

      Windows 7, Windows 8.1, Windows Server 2008, Windows Server 2008 R2, Windows Server 2012, Windows Server 2012 R2

        • Windows 7, Windows 8.1, Windows Server 2008, Windows Server 2008 R2, Windows Server 2012, Windows Server 2012R2.


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


        Requirements for the SSMA for Sybase Extension Pack:
        • SQL Server 2005 or higher.
        • Microsoft Windows Installer 3.1 or a later version.
        • The Sybase ASE OLEDB or ADO.NET or ODBC provider and connectivity to the Sybase ASE database server that contains the databases you want to migrate. You can install providers from the Sybase ASE product media.
      • After the download, you must extract the installation files before you can install SSMA for Sybase.

        Installing the SSMA for Sybase Client
        1. Double-click SSMA for Sybase.exe.
        2. On the 'Welcome' page, click Next.
        3. If you do not have the prerequisite Sybase OLE DB provider installed, a message will appear indicating that you must first install the providers. You can install the Sybase OLE DB provider from the Sybase 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 Sybase Extension Pack on the SQL Server machine.
        Installing the SSMA for Sybase 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 Sybase Extension Pack.exe file.
        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 Sybase 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. If Install Tester Database option is checked the tester ssmatesterdb database will be created.
        9. To install the utilities to another instance of SQL Server, select Yes, and then click Next. Or, to exit the wizard, click No.

    Popular downloads

    Loading your results, please wait...

    Free PC updates

    • Security patches
    • Software updates
    • Service packs
    • Hardware drivers

    Microsoft suggests

    Download a free trial of Windows Server 2012 R2.
    Windows Server 2012 R2 free trial
    Experience the new and enhanced capabilities.
    Free trial