0

I've used red-gate's sql compare with sqlserver for checking table/index/proc differences, is there anything similar for postgres?

What I want to do is figure out between development, QA, and production databases if there are any indexes or other schema changes in case something was missed.

1

2 Answers 2

0

Here is one implementation that will do what you are looking for: http://sqlmanager.net/en/products/postgresql/dbcomparer

0

Check_postgres from bucardo has a schema diff option. http://bucardo.org/check_postgres/check_postgres.pl.html#same_schema This a perl-based script I have used and found handy.

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .