Source Control Integration for dedicated SQL pool in Azure Synapse Analytics
This tutorial outlines how to integrate your SQL Server Data Tools (SSDT) database project with source control. Source control integration is the first step in building your continuous integration and deployment pipeline with the dedicated SQL pool resource in Azure Synapse Analytics.
Before you begin
- Sign up for an Azure DevOps organization
- Go through the Create and Connect tutorial
- Install Visual Studio 2019
Set up and connect to Azure DevOps
In your Azure DevOps Organization, create a project that will host your SSDT database project via an Azure Repo repository.
Open Visual Studio and connect to your Azure DevOps organization and project from step one by selecting Manage Connection.
Connect to your project by selecting Manage Connections, then Connect to a project.
Find the project you created in step one, select Connect.
Clone your Azure DevOps repository from your project to your local machine.
For more information about connecting projects using Visual Studio, see the Connect to projects in Team Explorer. For guidance on cloning a repo using Visual Studio, review the Clone an exiting Git repo article.
Create and connect your project
In Visual Studio, create a new SQL Server Database Project with both a directory and local Git repository in your local cloned repository.
Right-click on your empty sqlproject and import your data warehouse into the database project.
In Team Explorer in Visual Studio, commit your changes to your local Git repository.
Now that you have the changes committed locally in the cloned repository, sync and push your changes to your Azure Repo repository in your Azure DevOps project.
Verify changes have been pushed to your Azure Repo by updating a table column in your database project from Visual Studio SQL Server Data Tools (SSDT).
Commit and push the change from your local repository to your Azure Repo.
Verify the change has been pushed in your Azure Repo repository.
(Optional) Use Schema Compare and update the changes to your target dedicated SQL pool using SSDT to ensure the object definitions in your Azure Repo repository and local repository reflect your dedicated SQL pool.