MS SQL to Sybase ASE Migration Guide
Microsoft SQL Server (MSSQL) and Sybase Adaptive Server® Enterprise (ASE) are both SQL-based client/server relational database management systems used to support information systems. For various reasons, users of MSSQL may need to migrate their applications to ASE. Other customers may need to ensure that their applications are easily portable between the two products. Luckily, the unique history of these two products makes such conversion and portability relatively straightforward.
The two products have a common heritage because, until version 4.2, Microsoft simply licensed Sybase’s database server software; they were in fact two marketing entities for the same product1. Since that point, however, they have diverged. Microsoft has produced versions 6.0, 6.5, 7.0, 2000 and 2005 of Microsoft SQL Server, while Sybase has produced versions 4.8, 4.9, System 10 and System 11 of SQL Server and versions 11.5, 11.9, 12, 12.5 and 15.0 of SQL Server’s descendant, Adaptive Server Enterprise.
This document is primarily intended to assist with the application migration process from MSSQL to ASE. By migration, in this context, we mean the process of changing an application so that it uses ASE, rather than MSSQL, as its underlying database management system; this involves moving the schema and data from MSSQL to ASE as well as re-directing the application. It is also intended to be of assistance to those software developers needing to develop applications that can be easily migrated between the products.
The white paper presents an overview of the differences between the two products, from the points of view of both the application developer and the DBA, and then describes a straightforward and systematic process for performing a migration from MSSQL to ASE