I've got an application developed using DBI, Oracle, and CGI. It works well
on this platform, but now I'm faced with the prospect or getting it to run
with a MySQL back end instead of Oracle. The differences between the two
implementations of SQL (especially date functions) are causing some problems,
and I've been thinking of writing some kind of parser that takes an SQL
statement in one flavour and converts it to the other. I was wondering if
anyone had done this kind of thing before. Am I reinventing someone else's
wheel, or barking up the wrong tree? I can't help feeling that there
must be tools to deal with this kind of thing already.
Thanks in advance,
Maria
