tests/Test-DbaLinkedServerConnection.Tests.ps1
|
$commandname = $MyInvocation.MyCommand.Name.Replace(".Tests.ps1", "") Write-Host -Object "Running $PSCommandpath" -ForegroundColor Cyan . "$PSScriptRoot\constants.ps1" Describe "$commandname Integration Tests" -Tag "IntegrationTests" { BeforeAll { Get-DbaProcess -SqlInstance $script:instance2 -Program 'dbatools PowerShell module - dbatools.io' | Stop-DbaProcess -WarningAction SilentlyContinue $server = Connect-DbaInstance -SqlInstance $script:instance2 -Database master $server.Query("EXEC master.dbo.sp_addlinkedserver @server = N'localhost', @srvproduct=N'SQL Server'") } AfterAll { Get-DbaProcess -SqlInstance $script:instance2 -Program 'dbatools PowerShell module - dbatools.io' | Stop-DbaProcess -WarningAction SilentlyContinue $server = Connect-DbaInstance -SqlInstance $script:instance2 -Database master $server.Query("EXEC master.dbo.sp_dropserver @server=N'localhost', @droplogins='droplogins'") } $results = Test-DbaLinkedServerConnection -SqlInstance $script:instance2 | Where-Object LinkedServerName -eq 'localhost' It "can connect to linked server 'localhost'" { $results.LinkedServerName -eq 'localhost' $results.Connectivity -eq $true } } |