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.