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

Beginnen Sie mit LAB02 Step 3 und dem zugehörigen main.yml-Workflow und vergleichen Sie die angewiesene Bereitstellung mit dem im Issue gezeigten bearbeiteten Workflow. Führen Sie den Workflow mit einem Azure SQL Database-Projekt aus und bestätigen Sie, dass der DotNet-Fehler behoben ist und der Build die DACPAC erzeugt und bereitstellt.

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