Hi Chris, > Is there anything that will help me at least migrate my > tables and data over into MySQL?
There's a program out there called access2mysql that automates the conversion for you. It's not 100% effective, but very very close. In the years I've used it I've only had a couple errors. > After that, what pitfalls await me in making my existing > code work on MySQL? Your connection string, of course, but also some of your SQL may need to be changed. MySQL uses a different syntax for limiting results. Instead of 'TOP X' at the beginning of the statement, use "LIMIT X" at the end (where X is a number, of course). You'll also need to replace "[" and "]" within your SQL statements with "`" (that's a backquote, top-left key, under escape, on a typical QWERTY keyboard). Dates are wrapped with "'" not "#". That's about it. You'll eventually need to learn the encoding requirements for apostrophes and backslashes and stuff. That information is here: http://dev.mysql.com/doc/mysql/en/String_syntax.html Regards, Shawn K. Hall http://12PointDesign.com/ http://ReliableAnswers.com/ '// ======================================================== He who asks is a fool for five minutes, but he who does not ask remains a fool forever. -- Chinese proverb --------------------------------------------------------------------- Home : http://groups.yahoo.com/group/active-server-pages --------------------------------------------------------------------- Post : [email protected] Subscribe : [EMAIL PROTECTED] Unsubscribe: [EMAIL PROTECTED] --------------------------------------------------------------------- Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/active-server-pages/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
