Security updates for SQL 2022, 2019, 2017, 2016 (#9547) #661
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| name: Run Replication Tests | |
| on: [push] | |
| defaults: | |
| run: | |
| shell: pwsh | |
| jobs: | |
| repl-tests-part1: | |
| runs-on: ubuntu-latest | |
| env: | |
| GITHUB_TOKEN: ${{secrets.GITHUB_TOKEN}} | |
| steps: | |
| - uses: actions/checkout@v3 | |
| - name: Install and cache PowerShell modules | |
| uses: potatoqualitee/[email protected] | |
| with: | |
| modules-to-cache: dbatools.library:2024.4.12 | |
| - name: Set encryption values | |
| run: | | |
| Import-Module ./dbatools.psd1 -Force | |
| Set-DbatoolsConfig -FullName sql.connection.trustcert -Value $true -Register | |
| Set-DbatoolsConfig -FullName sql.connection.encrypt -Value $false -Register | |
| Get-DbatoolsConfigValue -FullName sql.connection.encrypt | Write-Warning | |
| - name: Setup docker images | |
| run: | | |
| # create a shared network | |
| docker network create localnet | |
| # Expose engine and endpoint then setup a shared path for migrations | |
| docker run -p 1433:1433 --volume shared:/shared:z --name mssql1 --hostname mssql1 --network localnet -d dbatools/sqlinstance | |
| # Expose second engine and endpoint on different port | |
| docker run -p 14333:1433 --volume shared:/shared:z --name mssql2 --hostname mssql2 --network localnet -d dbatools/sqlinstance2 | |
| - name: Add hostname to hosts file | |
| run: | | |
| echo "127.0.0.1 mssql1 mssql2" | sudo tee -a /etc/hosts | |
| - name: 👥 Clone appveyor repo | |
| working-directory: /tmp | |
| run: | | |
| gh repo clone dataplat/appveyor-lab | |
| - name: Setup Replication | |
| run: | | |
| Import-Module ./dbatools.psd1 -Force | |
| # need some folders for our repl stuff | |
| docker exec mssql1 mkdir /shared/data /shared/repldata /var/opt/mssql/ReplData | |
| - name: Run replication tests part 1 | |
| run: | | |
| Import-Module ./dbatools.psd1 -Force | |
| # Disabled for now, it's suddenly failing | |
| # $null = Invoke-Pester ./tests/gh-actions-repl-1.ps1 -Output Detailed -PassThru -Verbose | |
| repl-tests-part2: | |
| runs-on: ubuntu-latest | |
| env: | |
| GITHUB_TOKEN: ${{secrets.GITHUB_TOKEN}} | |
| steps: | |
| - uses: actions/checkout@v3 | |
| - name: Install and cache PowerShell modules | |
| uses: potatoqualitee/[email protected] | |
| with: | |
| modules-to-cache: dbatools.library:2024.4.12 | |
| - name: Set encryption values | |
| run: | | |
| Import-Module ./dbatools.psd1 -Force | |
| Set-DbatoolsConfig -FullName sql.connection.trustcert -Value $true -Register | |
| Set-DbatoolsConfig -FullName sql.connection.encrypt -Value $false -Register | |
| Get-DbatoolsConfigValue -FullName sql.connection.encrypt | Write-Warning | |
| - name: Setup docker images | |
| run: | | |
| # create a shared network | |
| docker network create localnet | |
| # Expose engine and endpoint then setup a shared path for migrations | |
| docker run -p 1433:1433 --volume shared:/shared:z --name mssql1 --hostname mssql1 --network localnet -d dbatools/sqlinstance | |
| # Expose second engine and endpoint on different port | |
| docker run -p 14333:1433 --volume shared:/shared:z --name mssql2 --hostname mssql2 --network localnet -d dbatools/sqlinstance2 | |
| - name: Add hostname to hosts file | |
| run: | | |
| echo "127.0.0.1 mssql1 mssql2" | sudo tee -a /etc/hosts | |
| - name: 👥 Clone appveyor repo | |
| working-directory: /tmp | |
| run: | | |
| gh repo clone dataplat/appveyor-lab | |
| - name: Setup Replication | |
| run: | | |
| Import-Module ./dbatools.psd1 -Force | |
| # need some folders for our repl stuff | |
| docker exec mssql1 mkdir /shared/data /shared/repldata /var/opt/mssql/ReplData | |
| - name: Run replication tests part 2 | |
| if: env.TESTS_FIXED == 'true' | |
| run: | | |
| Import-Module ./dbatools.psd1 -Force | |
| $null = Invoke-Pester ./tests/gh-actions-repl-2.ps1 -Output Detailed -PassThru -Verbose | |
| repl-tests-part3: | |
| runs-on: ubuntu-latest | |
| env: | |
| GITHUB_TOKEN: ${{secrets.GITHUB_TOKEN}} | |
| steps: | |
| - uses: actions/checkout@v3 | |
| - name: Install and cache PowerShell modules | |
| uses: potatoqualitee/[email protected] | |
| with: | |
| modules-to-cache: dbatools.library:2024.4.12 | |
| - name: Set encryption values | |
| run: | | |
| Import-Module ./dbatools.psd1 -Force | |
| Set-DbatoolsConfig -FullName sql.connection.trustcert -Value $true -Register | |
| Set-DbatoolsConfig -FullName sql.connection.encrypt -Value $false -Register | |
| Get-DbatoolsConfigValue -FullName sql.connection.encrypt | Write-Warning | |
| - name: Setup docker images | |
| run: | | |
| # create a shared network | |
| docker network create localnet | |
| # Expose engine and endpoint then setup a shared path for migrations | |
| docker run -p 1433:1433 --volume shared:/shared:z --name mssql1 --hostname mssql1 --network localnet -d dbatools/sqlinstance | |
| # Expose second engine and endpoint on different port | |
| docker run -p 14333:1433 --volume shared:/shared:z --name mssql2 --hostname mssql2 --network localnet -d dbatools/sqlinstance2 | |
| - name: Add hostname to hosts file | |
| run: | | |
| echo "127.0.0.1 mssql1 mssql2" | sudo tee -a /etc/hosts | |
| - name: 👥 Clone appveyor repo | |
| working-directory: /tmp | |
| run: | | |
| gh repo clone dataplat/appveyor-lab | |
| - name: Setup Replication | |
| run: | | |
| Import-Module ./dbatools.psd1 -Force | |
| # need some folders for our repl stuff | |
| docker exec mssql1 mkdir /shared/data /shared/repldata /var/opt/mssql/ReplData | |
| - name: Run replication tests part 3 | |
| run: | | |
| Import-Module ./dbatools.psd1 -Force | |
| # Invoke-Pester ./tests/gh-actions-repl-3.ps1 -Output Detailed -PassThru -Verbose |