Can I change my Heroku Connect schema name?

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:

  1. Export your configuration from the Settings tab on your existing connection

  2. Create a new 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.

  3. Provision the connection but do not create mappings

  4. Import your configuration on the Settings tab

  5. Wait for your data to complete its initial synchronization

  6. Update your application to use your new schema

  7. Destroy your old connection

Ask on Stack Overflow

Engage with a community of passionate experts to get the answers you need

Ask on Stack Overflow

Heroku Support

Create a support ticket and our support experts will get back to you

Contact Heroku Support