Importing/Exporting Sql Server 2008 database into MySQL

Question

I have a relatively large database in SQL Server 2008R2 that I need to export to MySql. I tried the "Import and Export Data" option for SQL Server but it provides no option for exporting to MySQL

Please assist with the possible way on how to achieve this.

Answer 1

There's an open source application at sourceforge named MSSQL2MySQL that might work for you.

Answer 2

If I was you. I would have gone for Navicat

Its a brilliant software and a very simple UI to import and export data within different types of server

Cheers!!