You have an SDK-style SQL database project named MyDatabaseProject.sqlproj stored in a private GitHub repository. The repository contains the following GitHub Actions workflow:

YAML

name: Build and Deploy SQL Project

on:

push:

branches:

- main

workflow_dispatch:

jobs:

build-and-deploy:

runs-on: ubuntu-latest

permissions:

id-token: write

contents: read

steps:

- uses: actions/checkout@v4

- name: Build SQL project

run: dotnet build MyDatabaseProject.sqlproj

- name: Publish DACPAC

uses: azure/sql-action@v2