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!

Tell us a little about you first

RELATED RESOURCES

9
Aug
eBook: Database Migration

DB Best goes well beyond other migration service providers. We take a vested interest in your migration strategy, combining innovation with an accelerated ROI that meets your business needs.  The Database Migration projects are usually part of larger application modernization efforts. DB Best realizes that no two database mig...

27
Jul
eBook: How the detailed modernization roadmap helped reduce the number of servers in the data center by 96%

A major American provider of global eCommerce solutions was looking for a way to upgrade their extensive data processing system. We provided them with visibility into their system and built cost-effective and highly optimized modernization roadmap using our DBMSys tool. Using our detailed instructions they can substantially c...