I'm wondering if there exists an easy way to clone sql-instances between projects in Google Cloud. I understand that i can export the data to a bucket see img_1, but i find that a bit cumbersome ..
If anyone has a easy way to do this, it would be much appreciated.
There is no “quick” way to Clone your SQL instance between projects. A clone operation essentially needs to bundle these 3 operations into 1, and hence why it is possible to have a clone within a project but not outside the project.
A Cloud SQL clone can only occur within the project. What you are looking for is a backup and restore to a different project, effectively cloning the instance but manually.
There is an open feature request open for this type of request. I suggest that you “+1” yourself on that so that you are kept up to date on the development of the feature.
If you want to have “clone” your instance to a different project, you have 2 options:
Feel free to ask questions as you wish.
For those who are looking for a different approach:
We can also recover a backup from an instance in a project to a different project, as docs says here. This is an approach that is not automated but essentially manual.
