Re: Simple schema diff script in Perl

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(at)stonehenge(dot)com> escribió:

> >>>>> "hans" == hans <hans(at)welinux(dot)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 L. Schwartz - Stonehenge Consulting Services, Inc. - +1 503 777
> 0095
> <merlyn(at)stonehenge(dot)com> <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