A class to convert MySQL querys to MSSQL querys ?

perrohunter

hi !

Ive been googling for a while and I havnt found a solution to convert MySQL queries to MSSQL queries

The main problem, I think , resides on the LIMITs and such

Before I start reinventing the wheel I wanted to ask the experts if anyone knew or had a class to convert MySQL querys to MSSQL querys

Thanks in advance

bpat1434

I don't know of a class to convert them, but then again I tend to write SQL '99 standard code which works on all SQL servers. I'm thinking you might have to just manually go through and fix them yourself.

perrohunter

But i'd love to keep working on my system for mysql, and in case someone wants to use it on MSSQL he could without having to arrage again manually all the querys =(

Ive been thinking, I could analyze the query and break it into its main parts so I could rearrange em to do whatever i need.

I think the only uncompatible thing in my querys are the LIMITs

bpat1434

There are alternative ways to limit results. You could use php to do just that. The LIMIT clause is a MySQL extension of the SQL language, so that would have to be dropped. But you could fix this in php using:

$result = mysql_query($query);

$num = mysql_num_rows($result);

$start = 10;
$limit = 15;

$i=1;
while($row = mysql_fetch_assoc($result))
{
    if($i>=$start && $i< ($start+$limit))
        $results[] = $row;

$i++;
}

Then your requested rows are in the $results array.

perrohunter

indeed, however imagine using this on a table with 600,000 rows I'd had the database transferme the 600,000 rows just to cut the first 10 ?

besides, limits boost the query speed :/

laserlight

indeed, however imagine using this on a table with 600,000 rows I'd had the database transferme the 600,000 rows just to cut the first 10 ?

It probably depends on the implementation, but the database does not have to transfer the data from all 600K rows, only those that have been accessed via the result set cursor.