4 ms·
There is also a Javascript version of this at https://github.com/gimenete/dbdiff https://github.com/gimenete/dbdiff and a Go version at https://github.com/joncr
by cellis 9y ago
There is also a Javascript version of this at https://github.com/gimenete/dbdiff https://github.com/gimenete/dbdiff and a Go version at https://github.com/joncrlsn/pgdiff https://github.com/joncrlsn/pgdiff, each with varying degrees of completeness. As well as apgdiff (Java) https://github.com/fordfrog/apgdiff 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!
- ssahoo 9y agoWe 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.
- djrobstep 9y agoThat'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.
- ssahoo 9y agothis complicates the workflow where schema compare is necessary in source controls.
- discussedbefore 9y agoWould 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_Server_Compare_Tools&oldid=465811353 https://en.wikipedia.org/w/index.php?title=Microsoft_SQL_Ser...