engagelabsit / socautolinkdatabasesworkingfolder Goto Github PK

# RedGate - hard-coded to version 6, change it if you have another version.
$socPath = $env:LOCALAPPDATA + "\Red Gate\SQL Source Control 6\"
$SQLComparePath = Join-Path $CurrentFolder -ChildPath "Dependencies"
$SQLDataComparePath = Join-Path $CurrentFolder -ChildPath "Dependencies"
$SqlToolbeltLicenseSerialNumber = ""
$hooksPath = Join-Path $socPath "ReservedCommandLineHooks\$sourceControlName.xml"
$xmlConfigurationsFilePath = Join-Path $socPath LinkedDatabases.xml

#database scope settings (list of custom database "scope", scope is the "meaning" of the database and it needs the branch name for being a complete name)
$DB1Scope = 'DB1'
$DB2Scope = 'DB2'
$DB3Scope = 'DB3'
#database scripts (you can change the names of each script, and also the text within them)
$DB1CreationScript = '01 - Create database DB1.sql'
$DB2CreationScript = '02 - Create database DB2.sql'
$DB3CreationScript = '03 - Create database DB3.sql'
#endregion

#region WORKING VARIABLES

# list of needed database (specify the position = specify the sorting of scripts execution, if you need any)
$DB1Name = $DB1Scope+"_"+$BranchSuffix
$DB2Name = $DB2Scope+"_"+$BranchSuffix
$DB3Name = $DB3Scope+"_"+$BranchSuffix

$databases = (
        ($DB1Scope, $DB1Name, $DB1CreationScript, 1),
        ($DB2Scope, $DB2Name, $DB2CreationScript, 2),
        ($DB3Scope, $DB3Name, $DB3CreationScript, 3)
    )