Re: [GENERAL] Simple schema diff script in Perl

2010-09-19 Thread Sualeh Fatehi
If you are still looking for a program to compare databases, take a look at SchemaCrawler - http://schemacrawler.sourceforge.net Sualeh. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Simple schema diff script in Perl

2010-09-17 Thread Florian Weimer
sqlt-diff --to MySQL Schema1=MySQL Schema2=MySQL SchemaUpdate.mysql.sql i can't guess where is the database name or user to use, if it work with dumps i need to give the dump files and the database type... My version says: | Currently (v0.0900), only MySQL is supported by this code. I

[GENERAL] Simple schema diff script in Perl

2010-09-16 Thread hans
Hi, I was looking for a simple diff program to compare two schemas, i found two scripts out there but one compared everything and was too much for me, the other was a ruby script i wasn't able to run, so i wrote a little perl script that do the trick: http://www.welinux.cl/hans/dbdiff.pl

Re: [GENERAL] Simple schema diff script in Perl

2010-09-16 Thread Randal L. Schwartz
hans == hans h...@welinux.cl writes: hans Actually just compare tables and fields, for my current hans requirements is ok, i plan to add the sequences, but no more. I believe SQLFairy (aka SQL::Translator) can canonicalize schemas, and even give DDL to turn one schema into another. -- Randal

Re: [GENERAL] Simple schema diff script in Perl

2010-09-16 Thread hans
Hi, Thanks for the quick response, i installed sqlfaiyr and guess that sqlt-diff is what i'm loogin for, but i can't guess how to use it, do you have any call samples, i found this: sqlt-diff --to MySQL Schema1=MySQL Schema2=MySQL SchemaUpdate.mysql.sql i can't guess where is the database