sql-workflow.yml

# This is a workflow template to help you get started with Actions which has been updated with the sql-workflow (https://github.com/marketplace/actions/azure-sql-deploy)
# .github/workflows/sql-workflow.yml


name: sql-workflow

# Controls when the workflow will run
on:
  # Triggers the workflow on push or pull request events but only for the "main" branch and when .sql files in "database_ddl" folder have been changed
  push:
    branches: [ "main" ]
    paths:
      - 'database_ddls/**.sql'

  # Allows you to run this workflow manually from the Actions tab
  workflow_dispatch:

# A workflow run is made up of one or more jobs that can run sequentially or in parallel
jobs:
  # This workflow contains a single job called "build"
  build:
    # The type of runner that the job will run on
    runs-on: ubuntu-latest

    # Steps represent a sequence of tasks that will be executed as part of the job
    steps:
      # Checks-out your repository under $GITHUB_WORKSPACE, so your job can access it
      - uses: actions/checkout@v1
      - uses: azure/sql-action@v2
        with:        
          connection-string: ${{ secrets.AZURE_SQL_CONNECTION_STRING_IDWT_PRODUCTION }}
          path: './Database.sqlproj'
          action: 'publish'