Legacy Update: Get back online, activate, and install updates on your legacy Windows PC

This guide presents information on the most common issues encountered and possible solutions for migrating Sybase databases to SQL Server. The guide focuses on procedures for transferring the items in a Sybase database and on redirecting and redeploying DB-Library and CT-Library applications to use a migrated database.
Depending on the specific technologies used to host these client applications, at least three options are available for reconfiguring them:

1. Client applications can remain in their existing environment and be redirected to SQL Server.
2. Client applications previously executing under UNIX can be redeployed to the computer running Microsoft Windows®, hosted in the Microsoft Windows Services for UNIX (SFU) environment, and then redirected to SQL Server.
3. Client applications can be fully ported to the Microsoft Windows platform and rewritten to take advantage of Microsoft technologies and APIs.

This guide describes the first two options. The guide also discusses the following topics:

• Concepts behind Sybase database migration
• Migration scenario assessment
• Target sizing requirements
• Job aids for current state analysis
• Sybase migration toolkit (assess and migrate)
• Migration of database clients
• Validation of migrated database
• Migration of stored procedures and T-SQL
• FreeTDS and unixODBC as redeployment solutions for DBLib and CTLib
• Query tuning

The download package includes job aids. The Sybase migration toolkit is available through Microsoft Consulting Services (MCS) at http://www.microsoft.com/services/microsoftservices/cons.mspx

Send questions or feedback to us directly at [email protected].

Files

Status: Deleted This download is no longer available on microsoft.com. The downloads below are archives provided by the Internet Archive Wayback Machine from the Microsoft Download Center prior to January 2016.

No files found

File sizes and hashes are retrieved from the Wayback Machine’s indexes. They may not match the latest versions of files hosted on Microsoft servers.

• Adobe Acrobat Reader is required to view the documentation.

1. Click the download button at the right to download the .zip file.


2. To save the .pdf, do one of the following:

• If the file opens in Adobe Acrobat Reader, click on the floppy disc icon at the top left of the screen to save it.
• If Adobe Acrobat Reader is not installed on your machine, save the .pdf by clicking Save in the File Download dialog box that will open.