search

solgenomics / sgn

The code behind the Sol Genomics Network, Cassavabase and other Breedbase websites
https://solgenomics.net
MIT License
66 stars 35 forks source link

Calculate diffs on the database dumps for IITA and make them available in FTP account #942

Open lukasmueller opened 7 years ago

bauchetg commented 7 years ago

Free Ones: pgquarrel: http://eulerto.github.io/pgquarrel apgdiff: http://apgdiff.com/ Liquibase (Cross DBMS): http://www.liquibase.org WbSchemaDiff (Cross DBMS): http://www.sql-workbench.net/manual/compare-commands.html

Commercial: DB Comparer: http://www.sqlmanager.net/en/products/postgresql/dbcomparer Aqua Data Studio: http://docs.aquafold.com/docs-diff-schema.html DB Solo: http://www.dbsolo.com/index.html (30 day trial)

bauchetg commented 7 years ago

Other option we looked with Prasad (in case the diff is too slow for ex) would be to: 1- Make a dump without the genotypeprop table "value" field using --exclude-table=genotypeprop 2- Restore the save table in th enew dump using: pg_dump -t genotypeprop | psql new_dump_of _the_db