Migrate GCP CloudSQL and BigQuery Database

Question

I have a one time use case to copy the data and the schema of the existing databases of CloudSQL and BigQuery from one GCP Project to another one. Is there any preferred way of achieving this other than creating the schema and the databases and writing scripts to copy all the existing data?

There is no 1-step solution. See https://stackoverflow.com/questions/64590750/is-there-an-easy-way-to-clone-a-sql-instance-between-projects-in-google-cloud — Kevin Potgieter
– Kevin Potgieter, Commented Jul 30, 2021 at 10:40

Dharmaraj · Accepted Answer · 2021-07-30 15:06:30Z

1

For MySQL you can use Database migration service. For bigQuery, you can use data transfer service

edited Jul 30, 2021 at 15:06

Dharmaraj

51.3k8 gold badges67 silver badges100 bronze badges

answered Jul 30, 2021 at 15:03

guillaume blaquiere

76.5k3 gold badges65 silver badges102 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Migrate GCP CloudSQL and BigQuery Database

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related