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

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

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

Files

Status: Live This download is still available on microsoft.com. The downloads below will come directly from the Microsoft Download Center.

File	Size
MigrateMySQLtoSQLServer.docx SHA1: 360cd444562a8b8a42a62815641843f5a8a027a6	139 KB
SSMAAccess.docx SHA1: 7854057ff5467b6f8cf29cfa34500a8b1cca55b5	600 KB
SSMAOracle.docx SHA1: 6631d0551f9945aea073e78a42c6dbd3d6448498	320 KB
SSMASybase.docx SHA1: 71f0ecc0a1bd44fca77fdbaa719b08ddad04103b	342 KB

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.

• • Microsoft Word 2007

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