SolutionBase: Migrating a SQL Server database to MySQL 5.0
You can view logs to check to see how the bulk transfers work
Schema creation
The fifth step, Schema Creation, actually builds the target schema in the MySQL database. Its first screen has two choices: Create Objects Online, or Create Script File For Create Statements. You can select either or both. If the generated scripts had many errors, it may be easier to simply generate the script, hand edit it, and execute it later rather than open each object's script individually. It also serves as good documentation of the run.
The second screen runs the scripts and creates the schema. The final screen of the step shows any errors that occurred.
Data mapping
The sixth step, Data Mapping, prepares for the bulk transfer of data from SQL Server tables to the target MySQL tables just created. This step is a single options screen that lets you transfer the data online, or to create a script of INSERT statements to do it.
Bulk transfer
The seventh step, Bulk Transfer, processes the bulk transfers on a table by table basis. Clicking the "Advanced >>" tab will show you a log of the execution as you can see above. Be very careful of the log files that are created in this step! They contain logins and passwords for both source and target systems, in plain text. Be sure to remove these logs or otherwise secure them after they are created.
The fifth step, Schema Creation, actually builds the target schema in the MySQL database. Its first screen has two choices: Create Objects Online, or Create Script File For Create Statements. You can select either or both. If the generated scripts had many errors, it may be easier to simply generate the script, hand edit it, and execute it later rather than open each object's script individually. It also serves as good documentation of the run.
The second screen runs the scripts and creates the schema. The final screen of the step shows any errors that occurred.
Data mapping
The sixth step, Data Mapping, prepares for the bulk transfer of data from SQL Server tables to the target MySQL tables just created. This step is a single options screen that lets you transfer the data online, or to create a script of INSERT statements to do it.
Bulk transfer
The seventh step, Bulk Transfer, processes the bulk transfers on a table by table basis. Clicking the "Advanced >>" tab will show you a log of the execution as you can see above. Be very careful of the log files that are created in this step! They contain logins and passwords for both source and target systems, in plain text. Be sure to remove these logs or otherwise secure them after they are created.
