[GENERAL] A compare and/or sync. database structure?

2009-08-05 Thread durumd...@gmail.com
Hi! I wanna ask that which pg_dump command line needed if I want to compare two databases? I have many DBs, but all of them have two versions a development (local) DB and the online (web) DB. When I want to realize a new function, I develop it locally, and later I sync. it into online DB.

Re: [GENERAL] A compare and/or sync. database structure?

2009-08-05 Thread Guillaume Lelarge
Le mercredi 5 août 2009 à 10:13:44, durumd...@gmail.com a écrit : > [...] > So please help me with your experience: what is the best solution, what is > the possible problem that make mistakes with this plan, and how to realize > it easily? > You can try check_postgres.pl Perl script. The same_sch

Re: [GENERAL] A compare and/or sync. database structure?

2009-08-06 Thread durumd...@gmail.com
Hi! Thanks... Sorry, but this is not good solution for me, because of the webserver is not opened (port) to the net, and I must compare local, a web dbs. So I try to find a solution, that can create a "map" from structure in XML, text, etc., and I can get it with ftp and compare it... First I

Re: [GENERAL] A compare and/or sync. database structure?

2009-08-08 Thread Sualeh Fatehi
The free, open-source SchemaCrawler for SQL Server tool is desinged to do just this. You can take human-readable snapshots of the schema and data, for later comparison. Comparisons are done using a standard diff tool such as WinMerge. SchemaCrawler outputs details of your schema (tables, views, pro