Is there any driver to make MSSQL behave like MySQL ?

perrohunter

Hi !

I'm having such a bad time porting querys from MySQL to MSSQL that i just had the thought about if there could exist something that I could install on the MSSQL server so It accepted the MySQL querys ?

just a question,

cheers

sneakyimp

It's been my experience that different DBMS systems have little annoying differences. One way to mitigate this problem is to use an intermediary like Pear's MDB2 package. However, that may not solve the problem. It helps get around things like autoincrement fields (autoincrement concept doesn't really exist in PostGres, they use sequences instead). However, there may be other issues with the queries that won't be solved by this problem.

If you could install MySQL on the server, that would solve the problem 😉

perrohunter

Thanks or your reply

Yeah, my problem resides with the querys :/

the problem on installing mysql, is that another app need to access my table, and the other programmer is not willing to learn mysql syntax >_<

sneakyimp

Hm. This problem may not be as bad as you think. Most of the basics are the same between DBMS's. The biggest differences I have noticed between MySQL and other DBMS systems is that MySQL lets you insert records using the update syntax:

INSERT INTO table SET field1=value1, field2=value2

and others don't really support that.

I'm sure there's other stuff, but if you're only talking about one table, things might not be so bad.

perrohunter

The main problem resides that MSSQL don't have a clear LIMIT feature

Im having problems porting both LIMITS and JOINS :/

I get alot of errors and bugs :/

NogDog

The PEAR MDB2 package can deal with the limit issue, as will the ADOdb abstraction layer.