On Mon, Jul 19, 2004 at 05:00:05AM -0700, Ask Bjoern Hansen wrote: > [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/
There's also http://search.cpan.org/dist/SQL-Translator/ and http://search.cpan.org/dist/DBIx-DBSchema/ Tim.