Database type
Database can be migrated either from one MySQL instance of one server (Linux on Windows) to another MySQL instance of another server (Windows Server 2008) or from MySQL on one server (Linux Windows) to SQL Server 2005 on another server (Windows Server 2008).
Migrating data from MySQL to MySQL is simpler and more straightforward compared with migration from MySQL to SQL Server 2005. Migration of data from MySQL to SQL Server 2005 requires migrating not just the tables and their fields, but the data types of the fields, indexes, keys, etc. This specific issue is covered in the Database migration section later in the document.
Migration of a database from MySQL to SQL Server 2005 also requires the installation of a MySQL ODBC connector on Windows Server 2008. This driver helps create a link between the two types of database servers and facilitates the migration of tables. Installing the ODBC driver is covered in the Appendix. On the other hand, migrating data from MySQL on one server to MySQL on Windows Server 2008 does not require an ODBC driver.
Web site compatibility
The compatibility of an Apache-based Web site with IIS 7.0 and Windows Server 2008 should be determined before proceeding with the actual migration. Web sites hosted on Apache and Linux have different dependencies compared with Web sites hosted on IIS 7.0 and Windows Server 2008.
