Close
AlgoliaLogoLight
Close full mode
logo

Run database migration

Git RepositoryEdit on Github
Last update: an hour ago by aaronammReading time: 2 min

Simple GitHub Actions workflow to run database migration with dbup-cli

  • We suggest you to read How to setup and use dbup-cli before using this workflow.
name: Run database migration
on:
push:
branches:
- main
env:
DOTNET_VERSION: 5.0.x # Set the.NET version to use
jobs:
run-db-migration:
runs-on: ubuntu-latest
steps:
- name: Check out the later source code from "${{ github.ref }}" branch
uses: actions/[email protected]
- name: Setup .NET SDK version ${{ env.DOTNET_VERSION }}
uses: actions/setup-[email protected]
with:
dotnet-version: ${{ env.DOTNET_VERSION }}
- name: Install dbup-cli as a .NET global tool
run: dotnet tool install --global dbup-cli
- name: Apply a new schema version
working-directory: migration # All configuration file and schema version files are in this 'migration' folder.
env:
MYSQL_HOSTNAME: ${{ secrets.MYSQL_HOSTNAME }}
MYSQL_DATABASE: ${{ secrets.MYSQL_DATABASE }}
MYSQL_USERNAME: ${{ secrets.MYSQL_USERNAME }}
MYSQL_PASSWORD: ${{ secrets.MYSQL_PASSWORD }}
run: dbup upgrade
Previous
GitHub Actions VS Azure DevOps Pipelines
Next
Run unit test when creating a PR