Given the significant cost and availability difference between MySQL and MSSQL with local hosting providers, I am looking to convert some simpler projects to use MySQL. I'm wondering if this will be a very uncomfortable experience, or simply a matter of getting used to some differences w.r.t. EF, not in the DBs themselves.
I recently grew very frustrated that EF kept generating migrations that would fail on SqlCe, and require painful manual edits, e.g. SqlCe will not allow a column rename, so migrations must be updated to drop and recreate columns, a far more 'invasive' process.
If you have used MySql with EF, do you have any warnings or advice for me?