Blog Post

Azure Synapse Analytics Blog
7 MIN READ

Announcing General Availability of Cross-Subscription Restore for Dedicated SQL Pools

stevehow's avatar
stevehow
Icon for Microsoft rankMicrosoft
Apr 19, 2022
We are excited to announce the release of cross-subscription restore. This has been one of our top requested features from customers as it unlocks multiple scenarios from dev/test to simplified billi...
Updated Apr 13, 2022
Version 1.0
Synapse SQL
Erik_Sirok's avatar
Erik_Sirok
Copper Contributor
Dec 09, 2022

Hi ShravyaPusa, in your Synapse Workspace select the link near Resource group, there you have to Create a new Dedicated SQL pool (formerly SQL DW). You need just the server, you can delete the SQL pool linked to the SQL Server, after the SQL Server is deployed.

 

In the script you use then the name of the server you just created.

$TargetServerName="name_of_the_server_you_just_created" # Without sql.azuresynapse.net -- create new dedicated SQL pool (formerly DW)

 

This step restores the Synapse SQL Pool to the SQL DB Server.

# Restore database from a desired restore point of the source database to the target server in the desired subscription $RestoredDatabase = Restore-AzSqlDatabase –FromPointInTimeBackup –PointInTime $PointInTime -ResourceGroupName $TargetResourceGroupName ` -ServerName $TargetServerName -TargetDatabaseName $TargetDatabaseName –ResourceId $DatabaseID

 

You have to uncomment the last part of the script under the comment

# uncomment below cmdlets to perform one more restore to push the dedicated SQL pool to an existing workspace in the destination subscription

 

In those last three steps the SQL Pool is restored from SQL DB Server to the Synapse Workspace.