tests/Copy-DbaDatabase.Tests.ps1
|
$commandname = $MyInvocation.MyCommand.Name.Replace(".ps1", "") Write-Host -Object "Running $PSCommandpath" -ForegroundColor Cyan . "$PSScriptRoot\constants.ps1" Describe "$commandname Integration Tests" -Tags "IntegrationTests" { BeforeAll { $BackupLocation = "$script:appeyorlabrepo\singlerestore\singlerestore.bak" $NetworkPath = "C:\temp" $DBNameBackupRestore = "dbatoolsci_singlerestore" $DBNameAttachDetach = "dbatoolsci_detachattach" # cleanup foreach ($instance in $Instances) { Remove-DbaDatabase -SqlInstance $instance -Confirm:$false -Database $DBNameBackupRestore,$DBNameAttachDetach } } AfterAll { foreach ($instance in $Instances) { Remove-DbaDatabase -SqlInstance $instance -Confirm:$false -Database $DBNameBackupRestore,$DBNameAttachDetach } } # Restore and set owner for Single Restore $null = Restore-DbaDatabase -SqlInstance $script:instance1 -Path $script:appeyorlabrepo\singlerestore\singlerestore.bak -WithReplace -DatabaseName $DBNameBackupRestore Set-DbaDatabaseOwner -SqlInstance $script:instance1 -Database $DBNameBackupRestore -TargetLogin sa Context "Restores database with the same properties." { It "Should copy a database and retain its name, recovery model, and status." { Copy-DbaDatabase -Source $script:instance1 -Destination $script:instance2 -Database $DBNameBackupRestore -BackupRestore -NetworkShare $NetworkPath $db1 = Get-DbaDatabase -SqlInstance $script:instance1 -Database $DBNameBackupRestore $db1 | Should Not BeNullOrEmpty $db2 = Get-DbaDatabase -SqlInstance $script:instance2 -Database $DBNameBackupRestore $db2 | Should Not BeNullOrEmpty # Compare its valuable. $db1.Name | Should Be $db2.Name $db1.RecoveryModel | Should Be $db2.RecoveryModel $db1.Status | Should be $db2.Status } } Context "Doesn't write over existing databases" { It "Should just warn" { $result = Copy-DbaDatabase -Source $script:instance1 -Destination $script:instance2 -Database $DBNameBackupRestore -BackupRestore -NetworkShare $NetworkPath -WarningVariable warning 3>&1 $warning | Should Match "exists at destination" } } foreach ($instance in $Instances) { Remove-DbaDatabase -SqlInstance $instance -Confirm:$false -Database $DBNameBackupRestore } Context "Detach, copies and attaches database successfully." { It "Should be success" { $null = Restore-DbaDatabase -SqlInstance $script:instance1 -Path $script:appeyorlabrepo\detachattach\detachattach.bak -WithReplace -DatabaseName $DBNameAttachDetach $results = Copy-DbaDatabase -Source $script:instance1 -Destination $script:instance2 -Database $DBNameAttachDetach -DetachAttach -Reattach -Force -WarningAction SilentlyContinue $results.Status | Should Be "Successful" } } Context "Database with the same properties." { It "should not be null" { $db1 = (Connect-DbaSqlServer -SqlInstance localhost).Databases[$DBNameAttachDetach] $db2 = (Connect-DbaSqlServer -SqlInstance localhost\sql2016).Databases[$DBNameAttachDetach] $db1 | Should Not Be $null $db2 | Should Not Be $null $db1.Name | Should Be $DBNameAttachDetach $db2.Name | Should Be $DBNameAttachDetach } <# It "Name, recovery model, and status should match" { # This is crazy (Connect-DbaSqlServer -SqlInstance localhost).Databases['detachattach'].Name | Should Be (Connect-DbaSqlServer -SqlInstance localhost\sql2016).Databases['detachattach'].Name (Connect-DbaSqlServer -SqlInstance localhost).Databases['detachattach'].Tables.Count | Should Be (Connect-DbaSqlServer -SqlInstance localhost\sql2016).Databases['detachattach'].Tables.Count (Connect-DbaSqlServer -SqlInstance localhost).Databases['detachattach'].Status | Should Be (Connect-DbaSqlServer -SqlInstance localhost\sql2016).Databases['detachattach'].Status } } Context "Clean up" { foreach ($instance in $instances) { Get-DbaDatabase -SqlInstance $instance -NoSystemDb | Remove-DbaDatabase -Confirm:$false } #> } } |