Postgres Pro
Downloads
Home   >   mailing lists

Re: Simple schema diff script in Perl - Mailing list pgsql-general

From hans@welinux.cl
Subject Re: Simple schema diff script in Perl
Date
Msg-id 159244918.185.1284679132714.JavaMail.root@gondor.welinux.cl
Whole thread Raw
In response to Simple schema diff script in Perl  (hans@welinux.cl)
Responses Re: Simple schema diff script in Perl
List pgsql-general
Tree view 
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
howto 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
databasetype... 

Hans

----- "Randal L. Schwartz" <merlyn@stonehenge.com> escribió:

> >>>>> "hans" == hans  <hans@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 L. Schwartz - Stonehenge Consulting Services, Inc. - +1 503 777
> 0095
> <merlyn@stonehenge.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

pgsql-general by date:

Previous
From: merlyn@stonehenge.com (Randal L. Schwartz)
Date:
Subject: Re: Simple schema diff script in Perl
Next
From: Gissur Þórhallsson
Date:
Subject: Re: value