Migrate from MS SQL to MySQL?

Open Source applications aren’t just for us computer geeks anymore. Businesses are increasingly turning to Open Source applications for their enterprise software needs because they are less expensive and just as reliable as proprietary applications.
There are several good database administration apps, including Navicat that administrators can use to migrate SQL Server data to MySQL.
[b]Do you have experience migrating SQL Server to MySQL? Was is a smooth transition or did you have to struggle to make it work?[/b]