Migra – A schema diff tool for PostgreSQL

Re:Migra – A schema diff tool for PostgreSQL by cellis on Monday March 26, 2018 @12:30AM (#16676619)

There is also a Javascript version of this at https://github.com/gimenete/dbdiff and a Go version at https://github.com/joncrlsn/pgdiff, each with varying degrees of completeness. As well as apgdiff (Java) https://github.com/fordfrog/apgdiff ( these tools have been tried many times, and I've been keeping track of them :D ), I'm really tired of writing db migrations. Will try this out!

[ Parent | on HN ]

Re:Migra – A schema diff tool for PostgreSQL by discussedbefore on Thursday April 05, 2018 @01:42PM (#16767078)

Would appreciate more from what you've been tracking.

Someone put a lot of love into this list for MSSQL circa 2011: https://en.wikipedia.org/w/index.php?title=Microsoft_SQL_Ser...

[ Parent | on HN ]

Re:Migra – A schema diff tool for PostgreSQL by ssahoo on Monday March 26, 2018 @12:36AM (#16676635)

We used apgdiff for automated schema diff generation. 2.4 was released many years ago and lacks compatibility with PG 10. Looking for alternatives. Thanks for the mentions.

Edit - Migra does not compare pgdump outputs.

[ Parent | on HN ]

Re:Migra – A schema diff tool for PostgreSQL by djrobstep on Monday March 26, 2018 @12:47AM (#16676678)

That's right, migra does not compare dump outputs.

I've found that the best parser of PostgreSQL dump files is PostgreSQL, and don't want to reimplement that.

Hence, migra works directly on database connections. If you have a dump file you want to compare, you can just create a temporary database and load the dump into that first. There's an example in the docs of how to do this easily.

[ Parent | on HN ]

Re:Migra – A schema diff tool for PostgreSQL by ssahoo on Monday March 26, 2018 @12:57AM (#16676712)

this complicates the workflow where schema compare is necessary in source controls.

[ Parent | on HN ]