Tables
Below is a small example of the table translation. You will notice that we refactored index definition out of the create table statement and separated it to external create index statement. We do this so we can apply indexes AFTER your data is copied. That way, if there are any errors (for example, unique constraint errors), you will not lose a single record.
MySQL source definition
SQL Server target definition
May 17, 2012