White paper: Guide to migrating from Sybase ASE to SQL Server 2014 and Azure SQL Database using SSMA

Summary: This white paper covers known issues for migrating Sybase Adaptive Server Enterprise database to SQL Server 2014. Instructions for handling the differences between the two platforms are included. The paper describes how SQL Server Migration Assistant, the best tool for this type of migration, can help resolve various migration issues.

Writers: Yuri Rusakov (DB Best Technologies), Alexander Pavlov (DB Best Technologies), Nataliia Lakoshko (DB Best Technologies), Igor Yefimov (DB Best Technologies)

Technical Reviewer: Dmitry Balin (DB Best Technologies)

Published: November 2014

Applies to: SQL Server 2014, Azure SQL Database, SAP Sybase ASE, SQL Server Migration Assistant
It’s true that Sybase Adaptive Server Enterprise (ASE) and the Microsoft® SQL Server® 2014 database software share common roots. But ever since Sybase and Microsoft began developing their own versions of SQL Server, many differences between the two products have appeared. As a result, some cases of migrating from Sybase ASE to SQL Server 2014 may require certain efforts unless effective migration tools are used.
That’s where the Microsoft SQL Server Migration Assistant (SSMA) for Sybase can help. SSMA can migrate tables, views, indexes, triggers, and stored procedures. It frequently converts approximately 99–99.5 percent of source objects and Transact-SQL code. In most cases you need to perform just a few manual patches to produce the final converted result.
This paper was originally written for Microsoft by the team at DB Best Technologies.

Need help getting started? Check out our Database Migration to SQL Server Offer!