https://techcommunity.microsoft.com/blog/azuresynapseanalyticsblog/announcing-general-availability-of-cross-subscription-restore-for-dedicated-sql-/3280185

Microsoft has helped me in restoration. We had to map the permissions manually. That was the only tricky part. Rest all good.

Thanks for your response Steve. We are trying to refresh the data present in the production Synapse dedicated pool database into non production Synapse. We would like to know what...