MySql to MS SQL

Forum Moderators: open

Message Too Old, No Replies

MySql to MS SQL

What is involved with a Mysql to MS SQL migration?

Twister47

12:28 pm on Aug 10, 2006 (gmt 0)

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

8:26 pm on Aug 22, 2006 (gmt 0)

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.

MySql to MS SQL

What is involved with a Mysql to MS SQL migration?

Twister47

coopster

Join The Conversation

Moderators and Top Contributors

Hot Threads This Week