Contents
Can You migrate Sybase data to SQL Server?
After you have successfully loaded the Sybase Adaptive Server Enterprise (ASE) database objects into SQL Server or Azure SQL Database, you can migrate data from ASE to SQL Server or Azure SQL Database.
Is there a migration assistant for Sybase Adaptive Server?
Microsoft SQL Server Migration Assistant (SSMA) for Sybase Adaptive Server Enterprise (ASE) is a tool for migrating ASE databases to MicrosoftSQL Server 2012, MicrosoftSQL Server 2014, MicrosoftSQL Server 2016, MicrosoftSQL Server 2017 on Windows and Linux, MicrosoftSQL Server 2019 on Windows and Linux, or Microsoft Azure SQL Database.
How does migrating data work in SQL Server?
Migrating data is a bulk-load operation that moves rows of data from the ASE tables into SQL Server tables in transactions. The number of rows loaded into SQL Server or Azure SQL Database in each transaction is configured in the project settings. To view the migration messages, make sure that the Output pane is visible.
How to convert Sybase ASE to SQL Server?
Converting data types: Sybase ASE Sybase ASE SQL Server 1 BIGDATETIME Date and time with fraction DATETIME2 (6) 2 BIGINT 64-bit integer BIGINT 3 BIGTIME Time (Hour, minute, second and fraction) TIME (6) 4 BINARY ( n) Fixed-length binary string BINARY ( n)
How to convert Sybase ASE database objects to SQL?
It does not load the information into the instance of SQL Server or Azure SQL. You can then view the objects and their properties by using the SQL Server or Azure SQL Metadata Explorer. During the conversion, SSMA prints output messages to the Output pane and error messages to the Error List pane.
Do you have to install SSMA for Sybase ASE?
If the engine being used is Server Side Data Migration Engine, then before you migrate data, you must install the SSMA for Sybase ASE Extension Pack and the Sybase ASE providers on the computer that is running SSMA. The SQL Server Agent service must also be running.