Redgate Alternative For PostgreSQL

IT Support Forum Forums Databases PostgreSQL General Discussion Redgate Alternative For PostgreSQL

Tagged: ,

This topic contains 0 replies, has 1 voice, and was last updated by  Webmaster 11 months, 1 week ago.

  • Author
    Posts
  • #1545

    Webmaster
    Keymaster

    Today I was trying to find out if Redgate supports PostgreSQL. It does not, but there is an alternative to Redgate that can be used to compare PostgreSQL databases. This alternative is not a software solution, rather it’s something you can do with PostgreSQL. Here’s what I found:

    use pg_dump -s and then diff the results. This gives you a textual dump of the database, and for identical databases, it should work, provided the same version of pg_dump is used. You may have to grep out the comments depending on the version of pg_dump used.

    The one huge caveat here is that this dumps columns in their physical order, so you would have to make sure that all DDL scripts are run in the same order on both.

You must be logged in to reply to this topic.