For migrating my old database from MySQL to SQL Server, which edition is suitable, 2005 or 2008 R2? Some developers suggested me to stick to the old version.
Suggest Pros and Cons. I will be using with my .NET standalone Windows app.
I would recommend 2008 R2 over the 2005 Express Edition for the fact that the database size limit on 2005 Express is 4 GB, when 2008 bumped that up to 10 GB. RAM is still limited to a maximum of 1 GB.
There's also the addition of the hierarchyid, besides the fact of impending loss of support for 2005...