setup-sqlserver

The missing action for SQL Server 🎉

• Simpler than containers
• Works on Linux and Windows
• Supports different versions

Getting Started

Add it as a step to your workflow

    - uses: cyberdantes/setup-sqlserver@v1
      with:
        accept-eula: true

accept-eula confirms your acceptance of the End-User Licensing Agreement

Versions

Specify a version (defaults to the latest)

    - uses: cyberdantes/setup-sqlserver@v1
      with:
        accept-eula: true
        sqlserver-version: 2019

Currently supports

Version	2019	2017
ubuntu-20.04	✓
ubuntu-18.04	✓	✓
windows-2022	✓
windows-2019	✓
windows-2016	✓

Test against multiple versions

    strategy:
      matrix:
        sqlserver-version: [2019, 2017]
    steps:
    - uses: cyberdantes/setup-sqlserver@v1
      with:
        accept-eula: true
        sqlserver-version: ${{ matrix.sqlserver-version }}

Password

Specify a password (defaults to YourStrong!Passw0rd)

    - uses: cyberdantes/setup-sqlserver@v1
      with:
        accept-eula: true
        sqlserver-version: 2019
        password: MyCurrentSAPassword

Extra Steps

Create a database

    - run: sqlcmd -U SA -P 'YourStrong!Passw0rd' -Q 'CREATE DATABASE testdb'

Run queries

    - run: sqlcmd -U SA -P 'YourStrong!Passw0rd' -d testdb -Q 'SELECT @@VERSION'

Resources

Linux

• Install SQL Server and create a database on Ubuntu
• Unattended SQL Server installation script for Ubuntu

Windows

• Install SQL Server from the Command Prompt
• Automating SQL Server Deployment with Packer, Terraform, and Ansible

Contributing

Everyone is encouraged to help improve this project. Here are a few ways you can help:

• Report bugs
• Fix bugs and submit pull requests
• Write, clarify, or fix documentation
• Suggest or add new features