Source Control Integration for Azure SQL Data Warehouse

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 SQL Data Warehouse.

Before you begin

Set up and connect to Azure DevOps

  1. In your Azure DevOps Organization, create a project that will host your SSDT database project via an Azure Repo repository

    Create Project

  2. Open Visual Studio and connect to your Azure DevOps organization and project from step 1 by selecting “Manage Connections”

    Manage Connections

    Connect

  3. Clone your Azure Repo repository from your project to your local machine

    Clone repo

Create and connect your project

  1. In Visual Studio, create a new SQL Server Database Project with both a directory and local Git repository in your local cloned repository

    Create new project

  2. Right-click on your empty sqlproject and import your data warehouse into the database project

    Import Project

  3. In team explorer in Visual Studio, commit your all changes to your local Git repository

    Commit

  4. 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.

    Sync and Push - staging

    Sync and Push

Validation

  1. 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)

    Validate update column

  2. Commit and push the change from your local repository to your Azure Repo

    Push changes

  3. Verify the change has been pushed in your Azure Repo repository

    Verify

  4. (Optional) Use Schema Compare and update the changes to your target data warehouse using SSDT to ensure the object definitions in your Azure Repo repository and local repository reflect your data warehouse

Next steps