well, yeah. just translate it. there's not a lot that MySQL can do that MSDE can't, if that's what you mean. I'm unaware of any tools to do this automatically, of course.
RTFM - straight talk for web developers. Unmoderated, uncensored, occasionally unreadable
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.
decpersona
Member
310 Points
62 Posts
Migrating a MySQL script to MSDE
Mar 29, 2004 12:33 AM|LINK
Atrax
All-Star
18705 Points
3733 Posts
Re: Migrating a MySQL script to MSDE
May 04, 2004 03:50 AM|LINK
Jason Brown - MVP, IIS
Caddre
All-Star
26581 Points
5308 Posts
Re: Migrating a MySQL script to MSDE
May 03, 2005 05:44 AM|LINK
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.
Gift Peddie