tests/Export-DbaDacPackage.Tests.ps1
|
$CommandName = $MyInvocation.MyCommand.Name.Replace(".Tests.ps1", "") Write-Host -Object "Running $PSCommandpath" -ForegroundColor Cyan . "$PSScriptRoot\constants.ps1" Describe "$commandname Integration Tests" -Tags "IntegrationTests" { BeforeAll { try { $dbname = "dbatoolsci_exportdacpac" $server = Connect-DbaInstance -SqlInstance $script:instance1 $null = $server.Query("Create Database [$dbname]") $db = Get-DbaDatabase -SqlInstance $script:instance1 -Database $dbname $null = $db.Query("CREATE TABLE dbo.example (id int); INSERT dbo.example SELECT top 100 1 FROM sys.objects") } catch { } # No idea why appveyor can't handle this } AfterAll { Remove-DbaDatabase -SqlInstance $script:instance1 -Database $dbname -Confirm:$false } if ((Get-DbaTable -SqlInstance $script:instance1 -Database $dbname -Table example)) { # Sometimes appveyor bombs It "exports a dacpac" { $results = Export-DbaDacPackage -SqlInstance $script:instance1 -Database $dbname if (($results).Path) { Remove-Item -Confirm:$false -Path ($results).Path -ErrorAction SilentlyContinue } } } } |