How to export SQL Server database to MySQL? [duplicate]
You can use MySQL Workbench which provides a way to quickly migrate data and applications from Microsoft SQL Server to MySQL employing less time and effort.
This tool has a lot of cool features like:
- Database migrations - enables migrations from Microsoft SQL Server, Sybase ASE and PostgreSQL.
- Migration project management - allows migrations to be configured, copied, edited, executed and scheduled.
I use sqlyog to migrate from mssql to mysql. I tried Migration toolkit and workbench but liked sqlyog for its SJA. I could schedule the import process and could do incremental import using WHERE clause.
PhpMyAdmin has a Import wizard that lets you import a MSSQL file type too.
See http://dev.mysql.com/doc/refman/5.1/en/sql-mode.html for the types of DB scripts it supports.