question

michaelchau2 avatar image
1 Vote"
michaelchau2 asked ·

How to join the current Azure DW database to Synapse Database Pool ?

As captioned title, How to join the current Azure DW database to Synapse Database Pool ?
I found in synapse studio , you can only create a new DW pool , instead of add.

azure-synapse-analytics
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

VaibhavChaudhari avatar image
0 Votes"
VaibhavChaudhari answered ·

Currently we can't add existing SQL DW to Synapse. There is no option for that at this moment. Only option is to backup existing SQL DW and restore but that's anyway new SQL DW in synapse.


If the response helped, do "Accept Answer" and upvote it - Vaibhav

· 1 ·
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi Vaibhav,

Is there plans to change this?
With no auto pause / shutdown option and no ability to disable geo-replicated backups I cannot imagine that many people will be rushing to use this option.

-rob

0 Votes 0 ·