Re: Schema comparison tool?

In article <34o1hu$ck2@laugh.agcs.com> tomasr@agcs.com (Roger Tomas) writes: >Looking for a tool to compare database schemas and (1) generate >SQL script to convert one to the other, (2) report differences >in a manner more meaningful than UNIX diff. Tool should >take as input either to Informix database names or 2 files >containing SQL schemas (preferably output from Informix's >dbschema tool. > >Prefer shareware but commercial ok too. > I've written a simple isqlperl program that given the old database name and an SQL file of CREATE [TABLE/INDEX] commands, lists the differences then (attempts) to convert the tables:- dbalter old_database_name new_database.sql I've been using it with xx.xx.3 SE, mainly to bring customer database upto date with the development version. I'd hoped that more recent versions of Informix would've made this easier :-( If it works for you, it *may* be useful. If anyone is interested, mail or post. -- Chris Benson Work: chrisb@stukeley.demon.co.uk Home: chrisb@jesmond.demon.co.uk