Ovid wrote: > Hi all, > > I'm not proposing to write a Test::SQL module, but I am tired of having > the following two things not being equivalent: > > CREATE TABLE foo ( > id INTEGER NOT NULL PRIMARY KEY, > name VARCHAR(32) NOT NULL, > title > age INTEGER > ); > > And: > > create table foo ( > id INTEGER NOT NULL PRIMARY KEY, > name VARCHAR(32) NOT NULL, > age integer > ); >
Have you looked at SQL::Translator? Specifically sqlt-diff would be very helpful in comparing 2 schemas and show what differences there might, or might not be. It's all part of the sqlfairy.sourceforge.net project. -- Michael Peters Developer Plus Three, LP
