Migrating Dedicated SQL Pool to Serverless

Question

Migrating Dedicated SQL Pool to Serverless

Anonymous

Currently the setup is a dedicated sql pool (DW300). The tables are external tables, which have parquets as a source. We would like to migrate this to serverless. How can we do this migration ?

KranthiPakala-MSFT 46,642 Reputation points Microsoft Employee Moderator

2023-10-02T16:45:07.0566667+00:00

@Anonymous Just checking in to see if the below information was helpful. If it answers your query, please do click Accept Answer and Yes for "was this answer helpful", as it might be beneficial to other community members reading this thread. If you have any further query, do let us know.

Thank you
KranthiPakala-MSFT 46,642 Reputation points Microsoft Employee Moderator

2023-10-06T01:22:58.71+00:00

@Anonymous We still have not heard back from you. Just wanted to check if the below information was helpful? If it answers your query, please do click Accept Answer and Yes for "was this answer helpful", as it might be beneficial to other community members reading this thread. And, if you have any further query do let us know.

Thank you

1 answer

Your answer

KranthiPakala-MSFT 46,642 Reputation points Microsoft Employee Moderator

2023-10-02T16:45:07.0566667+00:00

@Anonymous Just checking in to see if the below information was helpful. If it answers your query, please do click Accept Answer and Yes for "was this answer helpful", as it might be beneficial to other community members reading this thread. If you have any further query, do let us know.

Thank you
KranthiPakala-MSFT 46,642 Reputation points Microsoft Employee Moderator

2023-10-06T01:22:58.71+00:00

@Anonymous We still have not heard back from you. Just wanted to check if the below information was helpful? If it answers your query, please do click Accept Answer and Yes for "was this answer helpful", as it might be beneficial to other community members reading this thread. And, if you have any further query do let us know.

Thank you

Answer 1

KranthiPakala-MSFT 46,642 Microsoft Employee Moderator

@Anonymous Welcome to Microsoft Q&A forum and thanks for reaching out here.

I don't think there is a direct migration services as there quite a few differences betwee Dedicated External tables V/s Serverless External tables.

I recommend going through this document to have a better understanding of the difference first and then manually creating the Serverless external tables or by updating the Dedicated SQL pool external table Create scripts to allign with Serverless External tables Create syntax.

Share via

Migrating Dedicated SQL Pool to Serverless

1 answer

Your answer