Thread: Need Tool to sync databases with 8.3.1
All, I used to rave about how great the EMS PostgreSQL tools were, but lately I've been disappointed by the lack of support for their Database Comparer 2007 for PostgreSQL. I need a tool that will compare 2 database schemas and allow me to migrate changes from one database to another. What tools do the rest of you use to accomplish this task? As the name suggests, Database Comparer 2007 for PostgreSQL seems to have stopped development some time back in 2007 and it will not work with PostgreSQL 8.3+. In addition, several of the bugs I encounter with 8.2.4 databases make it a show stopper there too. I don't know how else to best accomplish my goals other than dumping 2 schemas, running a diff and manually syncing the 2 until the diffs go away. Suggestions for alternatives? I don't mind spending money if it'll get the job done. -- Dante
D. Dante Lorenso wrote on 15.06.2008 01:00: > I need a tool that will compare 2 database schemas and allow me to > migrate changes from one database to another. What tools do the rest of > you use to accomplish this task? You can try my SQL Workbench/J:. http://www.sql-workbench.net/manual/wb-commands.html#command-schema-diff It writes out the differences as an XML file. I have sample XSLT transformations to create SQL statements out of that XML on my homepage as well: http://www.sql-workbench.net/xslt.html Regards Thomas
Hi all,
reopening this thread, because I just received e-mail from EMS that they just release EMS DB Comparer with PostgreSQL 8.3 support.
I'm going to evaluate this, so I realized people here may be interested.
http://sqlmanager.net/en/products/postgresql/dbcomparer/download
Thanks,
Jozef
--
S pozdravom / Best regards,
Jozef Ševčík
sevcik@styxys.com
+420 608 782 813
+420 222 364 769
reopening this thread, because I just received e-mail from EMS that they just release EMS DB Comparer with PostgreSQL 8.3 support.
I'm going to evaluate this, so I realized people here may be interested.
http://sqlmanager.net/en/products/postgresql/dbcomparer/download
Thanks,
Jozef
2008/6/15 D. Dante Lorenso <dante@larkspark.com>
All,
I used to rave about how great the EMS PostgreSQL tools were, but lately I've been disappointed by the lack of support for their Database Comparer 2007 for PostgreSQL.
I need a tool that will compare 2 database schemas and allow me to migrate changes from one database to another. What tools do the rest of you use to accomplish this task?
As the name suggests, Database Comparer 2007 for PostgreSQL seems to have stopped development some time back in 2007 and it will not work with PostgreSQL 8.3+. In addition, several of the bugs I encounter with 8.2.4 databases make it a show stopper there too.
I don't know how else to best accomplish my goals other than dumping 2 schemas, running a diff and manually syncing the 2 until the diffs go away.
Suggestions for alternatives? I don't mind spending money if it'll get the job done.
-- Dante
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
--
S pozdravom / Best regards,
Jozef Ševčík
sevcik@styxys.com
+420 608 782 813
+420 222 364 769
Hello, > reopening this thread, because I just received e-mail from EMS that they > just release EMS DB Comparer with PostgreSQL 8.3 support. > I'm going to evaluate this, so I realized people here may be interested. > http://sqlmanager.net/en/products/postgresql/dbcomparer/download this app looks and works really good, but there is no version for OSX :-( Does anybody know an application like this for OSX? Thanks, Stefan Sturm