Anonymous Monk has asked for the wisdom of the Perl Monks concerning the following question:

Is there any way to convert the SQL that uses Sybase database to the one that uses MySQL database, given similar schema ?

Replies are listed 'Best First'.
Re: Sybase to MySQL
by bichonfrise74 (Vicar) on Oct 06, 2009 at 17:23 UTC
    Try running the Sybase SQL and see what happens in MySQL. You might need a conversion table so that when you see this 'type' of Sybase SQL, then it needs to convert it to a MySQL equivalent before it is run in MySQL database.
[reply]
      Obvious differences: 
      Sybase:
SET rowcount 10
SELECT column FROM table

      [download]
      MySQL:
SELECT column FROM table
LIMIT 10

      [download]
[reply]
[d/l]
[select]

Back to Seekers of Perl Wisdom