In this migration guide, you will learn the differences between the MySQL and SQL Server 2005 database platforms, and the steps necessary to convert a MySQL database to SQL Server. This migration guide outlines the procedures, problems, and solutions for migrating from MySQL 5 to Microsoft SQL Server 2005.
Included in this document are three main sections:
| • | Migrating MySQL Data Types. Explains the data type mapping and adds remarks about the related conversion issues. |
| • | MySQL Migration Issues. Explores the challenges you might encounter when migrating from MySQL to SQL Server 2005 and offers possible solutions. |
| • | Migrating MySQL System Functions. Examines MySQL system function references, divided into equivalent functions, nonsupported functions, and emulated functions. |