I want to import everything including the indexes and foreign keys from my MS SQL database to mySQL. I know I need to use Innodb tables but how do I set this import up.
Currently, SQLyog does not support importing of indexes and foreign keys in its ODBC Import Tool. You have to create them using SQLyog's Index Manager (Table -> Manage Indexes) and Relationship Manager (Table -> Manage Relationships) after importing the data.
Importing of Indexes and Relationships are planned for SQLyog 4.1