I have a project that I am considering moving from a MS-SQL2008 db to a MySQL db. It is about 30 gigs in size in about 200 tables and 500 stored procedures. I also use uniqueidentifiers heavily in the database.
So here are actually a couple questions.
1. What are the pros and cons of doing this?
2. What is the equivalent of uniqueidentifier in mssql in mysql?
3. Do you think there would be a performance gain or loss?
4. Are there any good conversion programs out there to automate this?