I'm trying to do a database migration using GCP Database Migration Service
My source database is of Postgres
type (hosted on Heroku
), but the name of the database is not postgres
but rather something like d12bdsdjs
...
My question is ... is there a way for me to use the GCP Database Migration Service
to somehow migrate this database ? There seems to be no field on the form where I can provide this value in GCP console
... maybe I can somehow set it if I create my migration job
using the GCP SDK
or something ?
Please advise
CodePudding user response:
After reviewing your issue, it is confirmed that Heroku
is not currently supported.
But it appears that it is planned: The idea is to push apps from Heroku to GCP while also switching the database over to Cloud SQL PostgreSQL.
In conclusion, unfortunately, Database Migration Service
does not support Heroku PostgreSQL at the moment.
CodePudding user response:
Like from an on-prem database instance, where I have two databases for example like "postgres" and "dev" ... is it somehow possible to copy only the database with the name "dev" ? It seems that GCP Migration Service tries to copy "postgres"
Here are some alternative methods for migration 1, 2. These do not need Database Migration Service to Migrate an on-premise database to Cloud SQL. As your problem seems you already have a database named postgres
.