http://forums.asp.net/t/522279.aspx/1?Migrating+a+MySQL+script+to+MSDETue, 03 May 2005 05:44:02 -0400522279522279http://forums.asp.net/p/522279/522279.aspx/1?Migrating+a+MySQL+script+to+MSDE Is there any way to migrate a MySQL Script to conform to the MSDE version of SQL? 2004-03-29T00:33:48-05:00562912http://forums.asp.net/p/522279/562912.aspx/1?Re+Migrating+a+MySQL+script+to+MSDE 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. 2004-05-04T03:50:37-04:00914037http://forums.asp.net/p/522279/914037.aspx/1?Re+Migrating+a+MySQL+script+to+MSDE <p>There is no DRI(declarative referential integrity) in MySQL so most of your Joins will be OUTERJOIN while MSDE will have more INNERJOINS.&nbsp; That is the main difference and you have to convert all your SQL code to stored procs for MSDE.&nbsp; Hope this helps.</p> 2005-05-03T05:44:02-04:00