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 name or user to use, if it work with dumps i need to give the dump files and the database type... Hans ----- "Randal L. Schwartz" <merlyn@xxxxxxxxxxxxxx> escribió: > >>>>> "hans" == hans <hans@xxxxxxxxxx> 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 L. Schwartz - Stonehenge Consulting Services, Inc. - +1 503 777 > 0095 > <merlyn@xxxxxxxxxxxxxx> <URL:http://www.stonehenge.com/merlyn/> > Smalltalk/Perl/Unix consulting, Technical writing, Comedy, etc. etc. > See http://methodsandmessages.vox.com/ for Smalltalk and Seaside > discussion -- Hans Poo, WeLinux S.A. http://www.welinux.cl Oficina: +56-2-372.9770, Celular: 09-319.93.05 Bombero Ossa # 1010, Of: 526, Santiago -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
