One of my clients is contemplating moving his data from a SQL solution to MySQL. I am assembling a list of pros and cons on both DBs. Please share your best and your worst experiences with any of the two with me .. --- Hum - couldn't edit the typo in the heading - sorry about that.
In the early versions of MySql there was no support for triggers, SP, views and triggers But in the last version everything like this is added. It may not be working as well(have not tested). Another think i was missing in MySql is subquestions inside a main question i am not sure if this is added in the later versions of mysql. What i miss most about SQL is the execution plan when you design your querys. I would say another advantage with Mssql is the number of languages you can use wen you write sp:s (vba, tsql, java). You also have the datawarehouse add on and english query, the integration with other databases that is easyer on mssql. I would say you can look at these things, however, i have not tried mysql 5 myself yet. Looking forward to it though. It sounds i dont like mysqy, but i do.. I would say the biggest reason i like mysql is the price...