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

Paul Hernandez 631 Reputation points Microsoft Employee
2021-10-20T08:28:27.507+00:00

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
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,357 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. MartinJaffer-MSFT 26,021 Reputation points
    2021-10-21T15:33:08.513+00:00

    Hello @Paul Hernandez 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

    1 person found this answer helpful.