π Deploy changes to your SQL database easily with SQL projects or SQL scripts and sql-action for GitHub workflows
π fix for a non-standard port not being properly parsed, surfaced in #161 where connectivity to Azure SQL Managed Instance public endpoint would fail
thanks to @miljann995 for the collaboration!
go-sqlcmd powers parts of sql-action and has recently moved to their v1 release, announcement here completed in #176
xml2js
@azure/keyvault-keys
from 4.4.0 to 4.7.0π fix for Expand-Archive : is not a supported...
#149, where some Windows environments may have a version of PowerShell not compatible with unzipping files without a file extension
β€οΈ thanks to @emil-eklund and @JoshFieldstad for contributions to this release!
master
server-name
.- uses: azure/sql-action@v2
with:
# required, connection string incl the database and user authentication information
connection-string:
# required, path to either a .sql, .dacpac, or .sqlproj file
path:
# optional when using a .sql script, required otherwise
# sqlpackage action on the .dacpac or .sqlproj file, supported options are: Publish, Script, DeployReport, DriftReport
action:
# optional additional sqlpackage or go-sqlcmd arguments
arguments:
# optional additional dotnet build options when building a database project file
build-arguments:
β€οΈ Thank you @mayong43111 for the contributions to the webpack improvements!
runs-on:ubuntu-latest
) for both dacpac deployment and SQL script execution.server-name
input parameter is now optional. This change is non-breaking - if server-name
is present, that value will be used instead of the server name specified in the connection string.β€οΈ Thank you @zijchen, @caohai, @yorek, and @llali for contributions to these changes and code health!
Automate your Action workflows to deploy to an Azure SQL database using this option
# .github/workflows/sql-deploy.yml
on: [push]
jobs:
build:
runs-on: windows-latest
steps:
- uses: actions/checkout@v1
- uses: azure/actions/login@v1
with:
creds: ${{ secrets.AZURE_CREDENTIALS }}
- uses: Azure/sql-action@v1
with:
server-name: REPLACE_THIS_WITH_YOUR_SQL_SERVER_NAME
connection-string: ${{β―secrets.AZURE_SQL_CONNECTION_STRING }}
dacpac-package: './Database.dacpac'
Released under MIT License