testing-dbatools/TestConfig_local_instances.ps1 at main · andreasjordan/testing-dbatools · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
# Modify the $config hashtable to include configuration for the local instances.


# Configuration items for the local instances:

$config['host1'] = $(hostname)    # Replace with your primary server for most of the tests
$config['host2'] = 'SQL2022'      # Replace with your secondary server for tests that need an instance on a different host

$config['InstanceConfiguration'] = [ordered]@{
    Version          = 2022
}
if (Test-Path -Path 'C:\SQLServerFull') {
    # We are on an Azure virtual maschine with preinstalled SQL Server
    $config['InstanceConfiguration'].SourcePath = 'C:\SQLServerFull'
} elseif (Test-Path -Path '\\dc\FileServer\Software\SQLServer\ISO\SQLServer2022') {
    # We are on personal setup of Andreas Jordan
    $config['InstanceConfiguration'].SourcePath = '\\dc\FileServer\Software\SQLServer\ISO\SQLServer2022'
    $config['InstanceConfiguration'].UpdateSourcePath = '\\dc\FileServer\Software\SQLServer\CU'
} elseif (Test-Path -Path '\\dc\FileServer\SQLServer2022') {
    # We are on personal setup of Andreas Jordan
    $config['InstanceConfiguration'].SourcePath = '\\dc\FileServer\SQLServer2022'
    $config['InstanceConfiguration'].UpdateSourcePath = '\\dc\FileServer\SQLServerCU'
}

# Configuration items from constants.local.ps1.example:

# Define your local SQL Server instances
$config['instance1'] = "$($config['host1'])"                 # Replace with your first SQL Server instance
# Should be a default instance that listens on 1433 because of:
# Test-DbaConnection.Tests.ps1
$config['instance2'] = "$($config['host1'])\SQLInstance2"    # Replace with your second SQL Server instance
$config['instance3'] = "$($config['host1'])\SQLInstance3"    # Replace with your third SQL Server instance

# Array of SQL Server instances (used in the tests of Test-DbaNetworkLatency and Get-DbaTopResourceUsage)
$config['instances'] = @($config['instance1'], $config['instance2'])

# SQL Server credentials
# Replace 'YourPassword' with your actual password and 'sa' with your username if different
$securePassword = ConvertTo-SecureString "P#ssw0rd" -AsPlainText -Force
$config['SqlCred'] = New-Object System.Management.Automation.PSCredential ("sa", $securePassword)

<# Default parameter values for the tests
$config['Defaults'] = [System.Management.Automation.DefaultParameterDictionary]@{
    "*:SqlCredential"            = $config['SqlCred']
    "*:SourceSqlCredential"      = $config['SqlCred']
    "*:DestinationSqlCredential" = $config['SqlCred']
}
#>

# Additional configurations (needed for the test of Test-DbaDiskAlignment)
$config['dbatoolsci_computer'] = $config['host1']    # Replace if your CI computer is different

# If using SQL authentication for Instance2, specify the username and password (is used by the tests of Test-DbaDiskSpeed and Invoke-DbaDbDecryptObject)
#$config['instance2SQLUserName'] = $null        # Replace with username if applicable
#$config['instance2SQLPassword'] = $null        # Replace with password if applicable

# Detailed instance name for Instance2 (needed only for the test of Restore-DbaDatabase)
$config['instance2_detailed'] = "$($config['host1']),14333\SQLInstance2"  # Adjust port and instance name as necessary

# Path to your local AppVeyor lab repository (if applicable)
$config['appveyorlabrepo'] = "C:\GitHub\appveyor-lab"        # Replace with the correct path

# SSIS Server instance (needed only for the test of New-DbaSsisCatalog)
#$config['ssisserver'] = "localhost\SQLInstance2"              # Replace if using a different SSIS server

# Azure Blob storage configurations (if applicable) (used in the tests of [Copy|Backup|Restore]-DbaDatabase)
#$config['azureblob'] = "https://yourstorageaccount.blob.core.windows.net/sql"
#$config['azureblobaccount'] = "yourstorageaccount"            # Replace with your Azure Storage account name

# Azure SQL Server configurations (if applicable) (used in the test of Connect-DbaInstance and Invoke-DbaAzSqlDbTip)
#$config['azureserver'] = "yourazureserver.database.windows.net"  # Replace with your Azure SQL Server name
#$config['azuresqldblogin'] = "yourusername@yourdomain.com"       # Replace with your Azure SQL DB login

# Path to a large database backup file (if needed for tests) (needed in the test of Get-DbaEstimatedCompletionTime)
#$config['bigDatabaseBackup'] = "C:\path\to\yourdatabase.bak"     # Replace with the path to your .bak file

# URL to download the large database backup file (needed in the test of Get-DbaEstimatedCompletionTime)
#$config['bigDatabaseBackupSourceUrl'] = "https://yoururl.com/yourdatabase.bak"  # Replace with the actual URL