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

                               (c) Microsoft 2004

Released October 29, 2004
=================================================================================

Sybase Engine Migration to SQL Server Guide Download

Download: http://go.microsoft.com/fwlink/?LinkId=23113
TechNet: http://go.microsoft.com/fwlink/?LinkId=23114

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.

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 includes 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

=================================================================================

	
Folder contents of the Sybase_Engine_Migration_to_SQL_Server_Guide.zip download file:

<Sybase_Engine_Migration_to_SQL_Server_Guide>

	Sybase_Engine_Migration_to_SQL_Server_Guide.pdf
		Chapter 1: Introduction
		Chapter 2: Envisioning Phase
		Chapter 3: Planning Phase: Overview	
		Chapter 4: Planning Phase: Database
		Chapter 5: Planning Phase: Clients 
		Chapter 6: Planning Phase: Building the Development and Test Environments
		Chapter 7: Planning Phase: Assessing the Sybase Database Using SMT
		Chapter 8: Planning Phase: Creating the Project Plans
		Chapter 9: Developing Phase: Database
		Chapter 10: Developing Phase: Clients
		Chapter 11: Stabilizing Phase
		Chapter 12: Deploying Phase
		Chapter 13: Operation
		Appendix A: Development-Related Topics
		Appendix B: Sybase and SQL Server Architectural Differences
		Appendix C: Sybase Stored Procedure and Trigger Migration to Microsoft SQL Server
		Appendix D: Transact-SQL Behavioral Differences
		Appendix E: Tranasct-SQL Transformation Checklist
		Appendix F: Data Migration
		Appendix G: Cutover and Fallback Strategies
		Appendix H: Sybase Migration Toolkit Installation Guide
		Appendix I: Sybase Migration Toolkit User Guide
		Appendix J: FreeTDS and unixODBC Installation
		Appendix K: ActiveState Perl Installation
		Appendix L: Team Roles and Responsibilities
		Appendix M: Familiarizing with SQL Server Interfaces and Connectivity
		Glossary

	<V1.1 Job Aids>
		
		Application-questionnaire.xls
		Database-questionnaire.xls
		Jobs-and-Scripts-Questionnaire.xls
		Master-Test-Plan-Template.doc
		Sybase-Migration-Risk-Assessment-Tool.xls
		Pilot-Plan-Template.doc
		Project-Structure-Template.doc
		Server-Questionnaire.xls
		Sybase-Migration-Vision-and-Scope-Template.doc
	
	<V1.1 Scripts>
		db_ver_new.pl
		syb2ms-dbg.pl

=================================================================================
TERMS OF USE

We at Microsoft Corporation hope that the information in this download is valuable to you.

This download and all files contained within are subject to Microsoft's standard TERMS OF USE for microsoft.com.

The TERMS OF USE for this download are located at http://www.microsoft.com/info/cpyright.htm

