Postgres
You can get a list of all tables and fields with the command:
SELECT * FROM information_schema.columns WHERE table_schema = 'public'
Fedora export / import
In sufia 6 instance:
$ bundle exec sufia_export --models GenericFile=Chf::Export::GenericFileConverter,Collection=Chf::Export::CollectionConverter
- Open up fedora port to the other server so it can grab the binaries
Change all the 127.0.0.1 URIs to reflect actual host, e.g.
$ find tmp/chf-import -type f -name "*.json" -print0 | xargs -0 sed -i "s/127\.0\.0\.1/dev6.hydra.chemheritage.org/g"
Move the resulting directory full of exported data from tmp/export to the new server's tmp/import (or wherever desired; this can be provided to the import script)
On sufia 7 instance:
- configure sufia6_user and sufia6_password in fedora.yml
$ bunx sufia_import -d tmp/chf-import --json_mapping Chf::Import::GenericFileTranslator=generic_file_