Public/ps1/Configuration/Sql/Install-ApprxrRemoteControllerSQL.ps1

<#
    .SYNOPSIS
    Installs the remote controller SQL configuration for Apprxr.
 
    .DESCRIPTION
    Stores the SQL connection string and related configuration for remote controller operations in Apprxr.
 
    .PARAMETER Tenant
    The tenant name to store in the configuration.
 
    .PARAMETER Credential
    The PSCredential object containing the username and password to store securely.
 
    .PARAMETER SqlConnectionString
    The SQL connection string to store securely.
 
 
    .EXAMPLE
    Install-ApprxrRemoteControllerSQL -Tenant 'tenant1' -Credential (Get-Credential) -SqlConnectionString 'Server=.;Database=Test;...'
 
    .NOTES
    Used for setting up SQL connectivity for remote controller features in Apprxr.
#>

function Install-ApprxrRemoteControllerSQL
{    
    [CmdletBinding()]
    param(
        [Parameter(Mandatory)]
        [String]$Tenant,
        
        [System.Management.Automation.PSCredential]
        $Credential = $(Get-Credential),

        [Parameter(Mandatory)]
        [String]$SqlConnectionString
    )


    Set-ApprxrConfigurationValue -name SqlConnectionString -value $SqlConnectionString -secure

    Install-ApprxrConfigurationBase -Tenant $Tenant -Credential $Credential

    Log("Apprxr + SQL installed")
}