Servers

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

    Language:
    English
    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.
    • Version:

      1.1

      File Name:

      Sybase_Engine_Migration_to_SQL_Server_Guide.zip

      Date Published:

      11/1/2004

      File Size:

      3.6 MB

        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.
    • Supported Operating System

      Unix, Windows Server 2003

        • 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.
        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.
      • 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.

    Popular downloads

    Loading your results, please wait...

    Free PC updates

    • Security patches
    • Software updates
    • Service packs
    • Hardware drivers

    Microsoft suggests

    Download a free trial of Windows Server 2012 R2.
    Windows Server 2012 R2 free trial
    Experience the new and enhanced capabilities.
    Free trial