Issue
You provisioned Heroku Connect and chose a schema to store your data in but now you want to change it.
Resolution
There is no way to change the schema of an existing Heroku Connect add-on.
If you want to change your schema name with minimal downtime, you can:
-
Export your configuration from the Settings tab on your existing connection
-
Note Depending on the size of your data and the health of your existing database, you may want to create a new database for the new connection as well.
-
Provision the connection but do not create mappings
-
Import your configuration on the Settings tab
-
Wait for your data to complete its initial synchronization
-
Update your application to use your new schema
-
Destroy your old connection