DP-3020 - Lab 2 - Configure and Deploy CI/CD Pipelines - Issue

Comece com LAB02 Step 3 e seu workflow main.yml, comparando a implantação indicada com o workflow editado mostrado no issue. Execute o workflow com um projeto do Azure SQL Database e confirme que a falha do DotNet desapareceu e que o build produz e implanta o DACPAC.

LAB02 (CSS): Configure and deploy CI/CD pipelines for Azure SQL Database projects
Task: Create a GitHub Actions workflow
Step. 3: Copy the code below on your main.yml file. The code includes the steps for building and deploying your database project.

User have reported running the deployment with the Main.yml file as instructed fails with a DotNet failure [P1]. I have confirmed this behavior and have been able to bypass the issue using the following edited code in the Main.yml file [P2]:

name: Build and Deploy SQL Database Project

on:
  push:
    branches:
      - main

jobs:
  build:
    permissions:
      contents: read
      id-token: write

    runs-on: windows-latest

    steps:
      - name: Checkout repository
        uses: actions/checkout@v3

      # Install MSBuild (required for .sqlproj)
      - name: Setup MSBuild
        uses: microsoft/setup-msbuild@v2

      # Install sqlpackage (Windows version)
      - name: Install sqlpackage
        run: |
          dotnet tool install -g microsoft.sqlpackage

      - name: Login to Azure
        uses: azure/login@v1
        with:
          creds: ${{ secrets.AZURE_CREDENTIALS }}

      # Build SQL Project using MSBuild
      - name: Build SQL Project
        run: |
          msbuild .\MyDBProj\MyDBProj.sqlproj /p:Configuration=Release

      # Publish DACPAC to Azure SQL
      - name: Deploy DACPAC
        run: |
          sqlpackage /Action:Publish `
            /SourceFile:".\MyDBProj\bin\Release\MyDBProj.dacpac" `
            /TargetConnectionString:"${{ secrets.AZURE_CONN_STRING }}" `
            /p:DropObjectsNotInSource=true

[P1] - Deployment with the code as instructed

[P2] - Deployment with edited code above