Thread: How can I compare sql create script with running database?
If I already have a running database, how can I compare the tables in the database with the sql script to discover the differences? Regards, BTJ -- ----------------------------------------------------------------------------------------------- Bjørn T Johansen btj@havleik.no ----------------------------------------------------------------------------------------------- Someone wrote: "I understand that if you play a Windows CD backwards you hear strange Satanic messages" To which someone replied: "It's even worse than that; play it forwards and it installs Windows" -----------------------------------------------------------------------------------------------
On 05/06/2008 10:52, Bjørn T Johansen wrote: > If I already have a running database, how can I compare the tables in > the database with the sql script to discover the differences? You can use pg_dump with the -s option to dump the schema of the database, and run it through the diff tool of your choice. Ray. ------------------------------------------------------------------ Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland rod@iol.ie Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals ------------------------------------------------------------------
On Thu, 05 Jun 2008 11:06:36 +0100 Raymond O'Donnell <rod@iol.ie> wrote: > On 05/06/2008 10:52, Bjørn T Johansen wrote: > > If I already have a running database, how can I compare the tables in > > the database with the sql script to discover the differences? > > You can use pg_dump with the -s option to dump the schema of the > database, and run it through the diff tool of your choice. > > Ray. > Well, not really an option because I don't think the dump will be an exact match to the sql script.... BTJ
Hi, Bjørn T Johansen wrote: > On Thu, 05 Jun 2008 11:06:36 +0100 > Raymond O'Donnell <rod@iol.ie> wrote: > >> On 05/06/2008 10:52, Bjørn T Johansen wrote: >>> If I already have a running database, how can I compare the tables in >>> the database with the sql script to discover the differences? >> You can use pg_dump with the -s option to dump the schema of the >> database, and run it through the diff tool of your choice. >> >> Ray. >> > > Well, not really an option because I don't think the dump will be an exact match to the sql script.... > Unless you create all your objects with your script into a different Database on the server then use pg_dump -s on both and compare the result :-) Cheers Tino
Attachment
On Thu, 05 Jun 2008 15:28:55 +0200 Tino Wildenhain <tino@wildenhain.de> wrote: > Hi, > > Bjørn T Johansen wrote: > > On Thu, 05 Jun 2008 11:06:36 +0100 > > Raymond O'Donnell <rod@iol.ie> wrote: > > > >> On 05/06/2008 10:52, Bjørn T Johansen wrote: > >>> If I already have a running database, how can I compare the tables in > >>> the database with the sql script to discover the differences? > >> You can use pg_dump with the -s option to dump the schema of the > >> database, and run it through the diff tool of your choice. > >> > >> Ray. > >> > > > > Well, not really an option because I don't think the dump will be an exact match to the sql script.... > > > > Unless you create all your objects with your script into a different > Database on the server then use pg_dump -s on both and compare the > result :-) > > Cheers > Tino > That I could do.... :) BTJ