MySQL -> MSSQL

[aaron_karp]

So I have a pretty extensive program that need to be switched over from MySQL to MSSQL. My original assumption was that all I'd have to do would be to change the functions, like mysql_query to mssql_query

A friend recently told me, however, that I'd probaby have to end up rewriting all the queries too because of intrinstic differences in the SQL.

Any thoughts?

[hessian]

It really depends on what you use in your SQL Staments. Some of the functions are different, and some of the clause are different( IE, now() is getdate() and LIMIT is TOP). There are more mysql php functions than mssql, so you may run into problems there. If you are using pretty simple SQL statements, it really shouldn't be to bad.
vi -c 'g/mysql/s//mssql/g' -c 'wq' file.php

One thing to look at for, if you are using longtext datatype in mysql, mssql text(16) will not hold any where near the amout of data.

You are aware to be legal with connecting a MsSQL Server to a website, you have to buy an Interenet Connector Lic, at about $3,800 (Been about 4 years since I bought one, so may be higher) per Processor on the SQL Box. Perhaps that is fuel to keep who ever want you to change to re-think.

Hope this helps.
Hessian

[aaron_karp]

Thanks Hessian. I think my queries are mostly simple enough. The company already has the MSSQL server set up and paid for, to the best of my knowledge, and for security reasons they're not keen on installing mysql.

Doesn't sound like this should be too bad though. I'm sure I'll post back here once I try transfering it and all my queries fail =) You guys can help me translate.