Video: Migrating MySQL Data
This video covers the process of moving data from MySQL to SQL Server 2008 once the database structure has been migrated.
Note: SSMA includes an option to do partial data migration. See this blog article on how to modify the sql statement to specify subset of data to be migrated (the article uses Oracle as an example, but you can use the same steps to customize on SSMA for MySQL).
Check out other video in this series: