Database Migration

[plasterx]

Hi all,

I'm currently using MS SQL as my database. I've done up all the tables and my project is almost complete, but i need to change my database to MySQL . I was just wondering if there are any major things that i need to change in my statements/codings? Like the syntax or etc. Other than the connection to database syntax, are there anythign else? Please help . .urgent.

Thanks !!

[raf]

depends on what kind of statements you used. MsSQL uses JetSQL which differs for some things from ANSI SQL.

Things like 'SELECT TOP etc' ar typically JetSQL and they wount work for MySQL. Same with wildcards. "Group By" also works a bit different for MsSQL.

Basically, you'll need to go over your code or test all your functionalitys to see if they still produce the same result.