Sybase Business Intelligence Solutions - Database Management, Data Warehousing Software, Mobile Enterprise Applications and Messaging
Sybase Brand Color Bar
delete

Search for    in all of Sybase.com
view all search results right arrow
  blank
 
 
 
 
 
 
 
 
 
 

 
 
CLICK TO EXPAND NAVIGATION
CLICK TO EXPAND NAVIGATION
 
 
 
 
Support > Technical Documents > Document Types > White Paper-Technical > MS SQL to Sybase ASE Migration Guide  
RSS Feed
 
 
 

MS SQL to Sybase ASE Migration Guide

1 INTRODUCTION
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

Click here to view the complete document (PDF).


 

DOCUMENT ATTRIBUTES
Last Revised: Nov 10, 2006
Product: Adaptive Server Enterprise
Business or Technical: Technical
  
Content Id: 1047976
Infotype: White Paper-Technical
 
 
 

 
© Copyright 2014, Sybase Inc. - v 7.6 Home / Contact Us / Help / Jobs / Legal / Privacy / Code of Ethics