SQL Change Automation from GitHub Actions?

robrich

I'm at MVP Summit, and have a question. Do we have a story for SQL Change Automation on GitHub Actions in the same way we have a story in similar build & release tools like Azure DevOps pipelines, TeamCity, and Jenkins?

Sergio R

No, we don't have add-ons for GitHub.
In these cases we would recommend using the Powershell cmdlets.

https://documentation.red-gate.com/sca/deploying-database-changes/continuous-integration
https://documentation.red-gate.com/sca/deploying-database-changes/automated-deployments

mirving

Sorry for waking the dead but is there any plans on supporting github actions directly or is there any samples on how to use github actions for build and deploy using github actions?

robrich

The way I've solved this is to check in a tools directory with all the exe's I need, then call them from scripts called from GitHub Actions.  Now that containers exist for all the tools, one could use docker commands from Actions.  This isn't quite as clean as the action commands you can grab from GitHub's marketplace, but it isn't that difficult to build your own if you really want it.  Derive from Redgate's container, add an action.yml and README.md, and if you want to go full-circle, publish to the marketplace.  See also https://docs.github.com/en/actions/creating-actions/creating-a-docker-container-action and https://hub.docker.com/u/redgate