Best deployment strategy for Synapse Serverless SQL

Question

Best deployment strategy for Synapse Serverless SQL

Steven Vandeputte 6

Hi there,

what would be the best deployment & CI/CD strategy for Synapse Serverless SQL?
As a Serverless DB is a more a container of external tables, views & procedures than an actual database, we have some troubles with how we want to deploy or promote changes from one environment to another.

SSDT schema compare is not supported (or doesn't work), so it seems like we should fully recreate all Serverless objects on the new environment (recreation of External tables first & afterwards SQL views).

Is there anything on the roadmap that allows us to properly perform promotion of artefacts or schema compare with Serverless SQL?

Thanks!

KranthiPakala-MSFT 46,642 Reputation points Microsoft Employee Moderator

2021-10-04T23:55:33.09+00:00

Hi @Steven Vandeputte ,

Thanks for using Microsoft Q&A forum and posting your query.
We are reaching out to internal team to get additional info regarding this query and will get back to you as soon as we have an update from the team.

Thank you for your patience.

1 answer

Your answer

KranthiPakala-MSFT 46,642 Reputation points Microsoft Employee Moderator

2021-10-04T23:55:33.09+00:00

Hi @Steven Vandeputte ,

Thanks for using Microsoft Q&A forum and posting your query.
We are reaching out to internal team to get additional info regarding this query and will get back to you as soon as we have an update from the team.

Thank you for your patience.

Answer 1

KranthiPakala-MSFT 46,642 Microsoft Employee Moderator

Hi @Steven Vandeputte ,

Sorry for the delayed response.

SSDT is supported for dedicated, while serverless doesn’t support it now. For now product team has suggested to have GIT repository with all the definitions of views/external tables/data sources etc.

Currently only option to execute scripts via Azure DevOps is via PowerShell or by using extension “Azure SQL database deployment” and select Deploy type “SQL script file” and path to SQL script which should be executed targeting the Serverless endpoint as Azure SQL server.

At this time, we do not have any update about the road map plan from product team. But this could be a new feature request for Synapse. Hence I would recommend you to please submit a feature request thread by following the guidelines provided in this article: How to send ideas and suggestions to the Synapse team

Hope this info helps.

----------

Please don't forget to click on and upvote button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how
Want a reminder to come back and check responses? Here is how to subscribe to a notification
If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators

KranthiPakala-MSFT 46,642 Reputation points Microsoft Employee Moderator

2021-10-11T17:43:19.313+00:00

Hi @Steven Vandeputte ,

Just checking in to see if the above response was helpful. If it answers your query, please do consider to click and upvote for the same as it could be beneficial to other community members. And, if you have any further query do let us know.

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

2021-10-12T20:36:10.303+00:00

Hi @Steven Vandeputte ,

We still have not heard back from you. Just wanted to check if you still need assistance on this? Incase if the above info helps, please do consider to click on "Accept Answer" and "Up-vote" on the post that helps you, as it can be beneficial to other community members

Thank you
NAGA SANDEEP KUMAR KAPA 51 Reputation points

2022-08-16T11:35:09.067+00:00

Hi ,

Can you please provide any links for the above statement to create serverless db's using ci/cd. Thanks in advance

Regards,
Sandeep

Share via

Best deployment strategy for Synapse Serverless SQL

1 answer

Your answer