When we announced Heroku Postgres Advanced in October, migration tooling for Postgres Classic databases was the first item on our roadmap. The first part of that tooling is available today: heroku data:pg:migrate .
heroku data:pg:migrate is a guided, interactive Heroku CLI workflow that moves a Postgres Classic tier database to Heroku Postgres Advanced. You don’t write dump scripts or copy settings by hand. You decide when the migration starts and we validate the copied data before you switch over.
heroku data:pg:migrate at a glance
One guided command : choose a source and destination, then prepare, start and track the migration, all from the Heroku CLI.
Destination created for you : optionally create the Advanced database during the flow, on the source’s Postgres major version and with networking to match its Private or Shield Space.
Online preparation : your Postgres Classic database keeps serving traffic while we prepare.
Downtime on your schedule : start the migration any time within 24 hours of…