Closed joechancellor closed 4 months ago
@joechancellor , Thanks for your feedback! We will investigate and update as appropriate.
@joechancellor I've delegated this to @realAngryAnalytics, a content author, to review and share their valuable insights.
Followed up with author.
sorry for the long delay in response @joechancellor cross subscription restore does not work with Az.Synapse cmdlets. If a customer would like to do cross subscription restore, they must use Az.Sql first to restore. Note the bottom of the code sample has a commented-out section that can be used to then take a dedicated SQL pool (formerly SQL DW) and copy it to a Synapse workspace using Az.Synapse cmdlets.
This code sample is what is required to do cross subscription restore. It is not ideal that Az.Synapse does not support this directly, however it is working code. Please try it and let us know if you have any issues.
Thanks for confirming @realAngryAnalytics.
The whole page is in regard to Azure Synapse Pool, and then at the bottom it gives reference to restore a synapse pool cross subscription using commands that are for Azure SQL Database not for AzSynapseSqlPool. Destined to fail, and there are people who won't understand why.
The correct subject for the powershell cmdlets should be Az.Synapse not Az.Sql.
Document Details
⚠ Do not edit this section. It is required for learn.microsoft.com ➟ GitHub issue linking.