[EMAIL PROTECTED] (Tony Bowden) writes: [...] > The two "best" ideas we've had so far are to either run the SQL in the > code against a temporary database, and then compare both SHOW CREATE > TABLE outputs, or to use something like SQL::Translator to convert both > lots of SQL to a common format. Both seem much too cumbersome, however. > > Anyone have any brighter ideas?
One variation that might work (and if it does, it'd also work on other databases) would be to use DB::Introspector. http://search.cpan.org/dist/DB-Introspector/ - ask -- ask bjoern hansen, http://www.askbjoernhansen.com/ !try; do();