Click Here to Install Silverlight*
United StatesChange|All Microsoft Sites
Microsoft
Download Center 
Search Advanced Search

Solution Guide for Sybase/UNIX to SQL Server 2000: Database Engine Migration and Application Interoperation

Brief Description
This guide presents the most common issues and 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.

On This Page

Quick Details
File Name:Sybase_Engine_Migration_to_SQL_Server_Guide.zip
Version:1
Date Published:11/1/2004
Language:English
Download Size:3.6 MB
Estimated Download Time: 9 min 56K

Overview

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 CISFdbk@microsoft.com.

 Top of page

System Requirements

  • Supported Operating Systems: Unix; Windows Server 2003
  • Adobe Acrobat Reader is required to view the documentation.

 Top of page

Instructions

  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.
  3. Open the .pdf with Acrobat 4.0 or later.

  4. For the .txt file, click the save as option in the File menu that appears when you click the file.
  5. For the .xls and .doc files, open in Microsoft Office.

 Top of page

Additional Information

Solution Accelerators are free, scenario-based guides and automations designed to help IT Professionals who are proactively planning, deploying, and operating IT systems using Microsoft products and technologies. Solution Accelerator scenarios focus on security and compliance, management and infrastructure, and communication and collaboration.

More Information about the Solution Accelerator Notifications Newsletter

Register to receive the Solution Accelerator Notifications newsletter so that you can stay informed about new Solution Accelerator releases and updates. The newsletter covers such areas of interest as

  • Communication & Collaboration
  • Security, Data Protection, & Recovery
  • Deployment
  • Operations & Management

You may also receive invitations to participate in accelerator development via beta programs and customer surveys. Solution Accelerator Notifications is currently available in English only.

 Top of page

 Top of page

What Others Are Downloading

Others who downloaded Solution Guide for Sybase/UNIX to SQL Server 2000: Database Engine Migration and Application Interoperation also downloaded:
  1. SQL Server White Papers: Guides to Migration from MySQL, Oracle, Sybase, or Microsoft Access to Microsoft SQL Server 2005

 Top of page

© 2009 Microsoft Corporation. All rights reserved. Contact Us |Terms of Use |Trademarks |Privacy Statement