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

SQL Server White Papers: Guides to Migration from MySQL, Oracle, Sybase, or Microsoft Access to Microsoft SQL Server 2005

Brief Description
Read these white papers to understand how to use SQL Server Migration Assistant (SSMA) to migrate to SQL Server 2005 from other database platforms.

On This Page

Quick Details
Version:1.0
Date Published:3/17/2008
Language:English
Download Size:146 KB - 1.4 MB*
*Download size depends on selected download components.

Overview

This release contains the following white papers:
  • Guide to Migrating from MySQL to SQL Server 2005 (114 pages)
  • Guide to Migrating from Oracle to SQL Server 2005 (161 pages)
  • Guide to Migrating from Sybase ASE to SQL Server 2005 (97 pages)
  • Guide to Migrating from Microsoft Access to SQL Server 2005 (52 pages)

Guide to Migrating from MySQL to SQL Server 2005
This migration guide explains the differences between the MySQL and SQL Server 2005 database platforms, and the steps necessary to convert a MySQL database to SQL Server.
Note: A Migration Assistant for migrating from MySQL to SQL Server is not available yet.

Guide to Migrating from Oracle to SQL Server 2005
This white paper explores challenges that arise when you migrate from an Oracle 7.3 database or later to SQL Server 2005. It describes the implementation differences of database objects, SQL dialects, and procedural code between the two platforms. The entire migration process using SQL Server Migration Assistant for Oracle (SSMA Oracle) is explained in depth, with a special focus on converting database objects and PL/SQL code.

Guide to Migrating from Sybase ASE to SQL Server 2005
This white paper covers known issues for migrating Sybase Adaptive Server Enterprise database to SQL Server 2005. Instructions for handling the differences between the two platforms are included. The paper describes how SQL Server Migration Assistant for Sybase, the best tool for this type of migration, can help resolve various migration issues.

Guide to Migrating from Microsoft Access to SQL Server 2005
This white paper covers migrating Microsoft Access databases to SQL Server 2005 and discusses the differences between the two platforms. SQL Server Migration Assistant for Access (SSMA Access) is the best tool for this type of migration; this paper tells you how to use it to mitigate potential problems in database conversion. For additional information, also see the white paper Microsoft Access or SQL Server 2005: What's Right in Your Organization?

 Top of page

System Requirements

  • Supported Operating Systems: Windows 2000 Service Pack 4; Windows Server 2003 Service Pack 2; Windows Vista; Windows XP Service Pack 2
  • Microsoft Word 2007

 Top of page

Instructions

To open the file immediately, click Open. To save the file to your computer for reading later, click Save.

 Top of page

Files in This Download

The links in this section correspond to separate files available in this download. Download the files most appropriate for you.
File Name:File Size

MigrateMySQLtoSQLServer.docx

146 KB

SSMAAccess.docx

657 KB

SSMAOracle.docx

325 KB

SSMASybase.docx

356 KB

 Top of page

 Top of page

What Others Are Downloading

Others who downloaded SQL Server White Papers: Guides to Migration from MySQL, Oracle, Sybase, or Microsoft Access to Microsoft SQL Server 2005 also downloaded:
  1. SQL Server Migration Assistant 2005 for Oracle V4.0
  2. SQL Server Migration Assistant for Oracle V3.1
  3. SQL Server 2008 Migration White Papers
  4. SQL Server Migration Assistant 2008 for Sybase ASE V4.0
  5. SQL Server 2008 Upgrade Technical Reference Guide

 Top of page

 Top of page


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