Restoring a backup to another project

I am in need to restore a backup across projects. I have setup the production database to be on a separate project from staging and uat, and I need to restore the production one into the uat database.

Is there a way to do this easily? maybe via CLI ? because the only solution i see, is to Replicate to a VM on GCP in the same network as production, download the backup. Then upload the backup to a VM in the UAT network and replicate back. And this will take hours.

So I am wondering if there is a better solution.

Thank you!

Restoring a backup from another project is currently not supported. There might be something in the Cloud roadmap that will make it possible, but I can’t say what and when atm. But, we are aware of the issue.