MySql to MS SQL

What is involved with a Mysql to MS SQL migration?

[Twister47]

I have a web app that was built on MySql. However due to server requirements for one client they will only allow MS Sql to be run.

I have never used MS Sql, so I don't know how similar they are if at all.

Anyone have experience with both and can offer some insight as to the differences, and if they think a MySQL to MS SQL migration would be difficult?

[coopster]

It all depends on the SQL syntax used. If you kept your code to standard SQL you won't have to do much of anything except migrate your data. Also, if you used any MySQL-specific APIs, functions, or otherwise you will need to convert those as well or find workarounds. This is one reason database abstraction layers are nice.