I've been searching Google and haven't come up with a clear solution. I have pretty much zero experience with MSSQL, I need to convert an MSSQL database to work with mySQL. Any suggestions or information?
I don't know whether you're looking to do this for free, but if you don't mind paying this could be an option for you. John
I've done several large conversions in the past. http://www.navicat.com/ supports SQL server as well as MySQL. You can export into a text based format and then import into a MySQL database. Their premium version includes support for SQL server and MySQL. I can't think of an easier way to do it than this. It's not a free product but they do offer a 30 day trial. In my experience it is well worth the cost if you do a lot of database development.
MySQL has a migration toolkit which allows you to migrate from Microsoft SQL Server to MySQL. Personally though I haven't tried it.