Preparing for Migration

Proper migration planning is extremely important to ensure a successful outcome. Before beginning the transition, review the schema of the MySQL database that is being migrated. Compare the MySQL data types to the SQL Server 2000 data types, making note of the differences. The "Comparing MySQL to Microsoft SQL Server" section of this paper provides a framework of comparable data types. Be aware that some MySQL database objects may be in conflict with SQL Server 2000 reserved words. These words are included in the following section. You should backup and copy the MySQL database files before using DTS to migrate to SQL Server 2000.

Microsoft TechNet: Migrating MySQL to SQL Server 2000