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.