There is no DRI(declarative referential integrity) in MySQL so most of your Joins will be OUTERJOIN while MSDE will have more INNERJOINS.  That is the main difference and you have to convert all your SQL code to stored procs for MSDE.  Hope this helps.