question

PaulHernandez-8067 avatar image
0 Votes"
PaulHernandez-8067 asked MartinJaffer-MSFT commented

DevOps Release Pipeline for SQL Server DB Projects and Synapse Workspace - Together or separated?

Hi everyone,

We are evaluating whether is better to release a SQL Server DB Project together in the same devops pipeline with the synapse workspace or is better to keep them in two different pipelines, which is the current state.

We kept them in separated repos but they are highly related and dependent on each other.

If only one of them has new changes this shouldn't be an overhead for any of the systems since pipeline tasks are smart enough to deploy things incrementally and do nothing if there are no changes.

Would you also keep both projects under one repo?

Best regards,

Paul

azure-synapse-analytics
5 |1600 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

MartinJaffer-MSFT avatar image
1 Vote"
MartinJaffer-MSFT answered MartinJaffer-MSFT commented

Hello @PaulHernandez-8067 and welcome to Microsoft Q&A.

In my opinion, using 2 repos inside one project makes more sense. By placing both inside the same project, they can share pipelines and work items. However I would keep the Synapse and SQL in separate repos. Sometimes accidents can happen, and the Data Factory portion of Synapse gets out of sync with the repository. By keeping separate, the mess can be contained.

https://github.com/MicrosoftDocs/azure-devops-docs/blob/master/docs/user-guide/plan-your-azure-devops-org-structure.md#one-vs-many-repos

· 2
5 |1600 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 @MartinJaffer-MSFT ,
thanks for your input.
At the end we decided to have two different repos since the branch strategy for data factory/synapse is quite rigid and you need to have a collaboration branch where new versions are first available after publish the artifacts.
Because this fundamental reason we will keep both, repos and pipelines separated.

0 Votes 0 ·

Thank you for the feedback.

0 Votes 0 ·