After working with databases for any length of time, we have all experienced issues which we are unable to replicate and suspect something has gone wrong with the latest database upgrade or the latest deployment script did not fully run.  MySQL structure comparison of each database allows you to quickly see what's changed in either the source or the target, and make the necessary changes to bring them back in sync.

How to Compare two MySQL databases and discover what is difference between the databases?

Step 1: point it at a master copy of your database and then the database you are experiencing the issue with:

Step 2: pgCompare shows me what is only in my source which is missing from my target

Step 3: Select the missing objects

Step 4:  Generate a deployment script to update my database

Step 5: Copy the script and run it against the database

Step 6: Press refresh in pgCompare to confirm the databases are now identical.  Now are databases are the same, the problem with the database is resolved.

Automate a PostgreSQL Database Deployment

If you want to be able to automate this process that is possible within the Flyway CLI - more details can be found here: - https://documentation.red-gate.com/fd/compare-two-databases-253394964.html

Tags: Postgres compare, PostgreSQL compare, How to compare two Postgres databases, How to compare two PostgreSQL databases, How to compare two Postgres databases, PostgreSQL schema comparison, Postgres schema comparison, PostgreSQL database diff tool, Postgres database diff tool, PostgreSQL version control, Postgres version control, PostgreSQL structure comparison, Postgres structure comparison