importing MySQL dump to SQL Server 2012

I have a database schema from MySQL which I want to import to SQL SERVER, I have tried dumping from MySQL with compatibility for SQL Server, but with no success. Tried dumping as Excel still no dice. Does anyone know another way to import this database with no records from MySQL to SQL SERVER 2012? Thanks for your time.

I tried Microsoft SQL Server Migration Assistant v6.0 for MySQL which did most of the work for converting the schema and migrating the data from MySQL to SQL Server.

• SSMA download page (New version v8.19: download page)

• SSMA team blog (SSMA documentation)

StackExchange Database Administrators Q#39462, answer score: 5