Export and import a Heroku database from one app to another app

commands-bash.bash

heroku addons:create heroku-postgresql:hobby-basic
heroku pg:wait
heroku info
heroku pg:backups capture
heroku maintenance:on

export DB_DUMP=`heroku pg:backups public-url -a export-app-name`
heroku pg:backups restore $DB_DUMP DATABASE_URL -a import-app-name

heroku pg:copy DATABASE_URL HEROKU_POSTGRESQL_PURPLE_URL
heroku pg:promote HEROKU_POSTGRESQL_PURPLE_URL
heroku maintenance:off
heroku pg:info

heroku-export-import-database.bash

export DB_DUMP=`heroku pg:backups public-url -a export-app-name`

heroku pg:backups restore $DB_DUMP DATABASE_URL -a import-app-name