Migrating to SQL Server from Other Database Products

SQL Server 2008 delivers exceptional value in database management and business intelligence causing many customers to choose SQL Server over other database solutions. The information on this page will help you find the resources needed to migrate your data to SQL Server 2008.

Because these papers are very long (most over 100 pages), reading them in an online format such as the Library becomes impractical, so we offer them as a downloadable Microsoft Word documents. To read these white papers, if you do not have Word 2007, you may need to download the Microsoft Office Compatibility Pack for Word, Excel, and PowerPoint 2007 File Formats from the Microsoft Download Center.

The information contained in each of these white papers applies to migrations to both SQL Server 2008 and SQL Server 2008 R2.

Migration White Papers

Guide to Migrating from MySQL to SQL Server 2008
In this migration guide you will learn the differences between the MySQL and SQL Server 2008 database platforms, and the steps necessary to convert a MySQL database to SQL Server.

Guide to Migrating from Oracle to SQL Server 2008
This white paper explores challenges that arise when you migrate from an Oracle 7.3 database or later to SQL Server 2008. 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 (SSMA) 2008 for Oracle is explained in depth, with a special focus on converting database objects and PL/SQL code.

Guide to Migrating from Informix to SQL Server 2008
This white paper explores challenges that arise when you migrate from an Informix 11 database to SQL Server 2008. It describes the implementation differences of database objects and procedural code between the two platforms. Emulation of system functions is also discussed.

Guide to Migrating from Sybase ASA to SQL Server 2008
This white paper explores challenges that arise when you migrate from a Sybase Adaptive Server Anywhere (ASA) database of version 9 or later to SQL Server 2008. It describes the implementation differences of database objects, SQL dialects, and procedural code between the two platforms.

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