Обсуждение: Pg schema diff tools Was: [ANNOUNCE] == PostgreSQL Weekly News - April 08 2007 ==
Pg schema diff tools Was: [ANNOUNCE] == PostgreSQL Weekly News - April 08 2007 ==
От
Markus Schiltknecht
Дата:
Hi, David Fetter wrote in the weekly news: > Another PostgreSQL Diff Tool 1.0.0_beta20 released. > http://pgfoundry.org/projects/apgdiff/ Why is it 'another' one? What others exist? (Specifically, are there ones, which don't depend on java?) Regards Markus
Re: Pg schema diff tools Was: [ANNOUNCE] == PostgreSQL Weekly News - April 08 2007 ==
От
Robert Treat
Дата:
On Monday 09 April 2007 05:35, Markus Schiltknecht wrote: > Hi, > > David Fetter wrote in the weekly news: > > Another PostgreSQL Diff Tool 1.0.0_beta20 released. > > http://pgfoundry.org/projects/apgdiff/ > > Why is it 'another' one? What others exist? (Specifically, are there > ones, which don't depend on java?) > Theres this one which uses tcl: https://sourceforge.net/projects/pgdiff And this one which is written in perl: http://gborg.postgresql.org/project/pgdiff/projdisplay.php And this one which is commercial but actually works :-P http://sqlmanager.net/en/products/postgresql/dbcomparer And I think there are some others floating around... -- Robert Treat Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL
Re: Pg schema diff tools Was: [ANNOUNCE] == PostgreSQL Weekly News - April 08 2007 ==
От
Markus Schiltknecht
Дата:
Hi, thanks for the links. I've had a quick look at the first two and comment my findings: Robert Treat wrote: > Theres this one which uses tcl: > https://sourceforge.net/projects/pgdiff Seems outdated: 2002, PostgreSQL 7.2, ~1500 lines of code. (which I don't really understand, I simply don't know TCL, sorry.) > And this one which is written in perl: > http://gborg.postgresql.org/project/pgdiff/projdisplay.php Yeah, perl is better with me ;-) Anyway, 2003 also isn't that up-to-date either. ~770 lines of code, but that might very well be sufficient in many cases. And as David Fetter pointed out, it's dangerous to rely on such tools, as they can never replace a change control process. Regards Markus
Re: Pg schema diff tools Was: [ANNOUNCE] == PostgreSQL Weekly News - April 08 2007 ==
От
"Merlin Moncure"
Дата:
On 4/10/07, Markus Schiltknecht <markus@bluegap.ch> wrote: > Robert Treat wrote: > > Theres this one which uses tcl: > > https://sourceforge.net/projects/pgdiff > > Seems outdated: 2002, PostgreSQL 7.2, ~1500 lines of code. (which I > don't really understand, I simply don't know TCL, sorry.) > > > And this one which is written in perl: > > http://gborg.postgresql.org/project/pgdiff/projdisplay.php > > Yeah, perl is better with me ;-) Anyway, 2003 also isn't that > up-to-date either. ~770 lines of code, but that might very well be > sufficient in many cases. > > And as David Fetter pointed out, it's dangerous to rely on such tools, > as they can never replace a change control process. no, but it's good to double check your change control process with a good diff tool. the sqlmanager tool is pretty good but not perfect. That being said, I think a hand crafted pl/pgsql script is probably the way to go. merlin