Migrating from MySQL to MSSQL

Making sure my scripts work in both

[Xedium]

I have a PHP application that uses basic SQL for storing its data. Currently, it's made for MySQL - If I want to make it support MSSQL also, what should I do? I know there's ADOdb, if I want to support tons of databases. Are there any glaring peculiarities to MSSQL that I should know of?

[txbakers]

Every database has its quirks and annoyances.

Migrating from mySQL 4 to mySQL 5 was a royal pain. I had to rewrite several key queries to conform with the new syntax rules.

You will encouter the same things in going from mySQL to MSSQL.

Just go slow and test, test, test before you release.

There is no magic elixir to help you do it.