** This is the Powershell script that is running in Octopus Deploy **
$productionDatabase = “Data Source=$ProductionDatabaseServer; Initial Catalog=$ProductionDatabaseName”
Test-DatabaseConnection $productionDatabase
Thanks for reaching out. This is a RedGate question that they’ll probably answer better than us. I’ve forwarded this question to RedGate support and they’ll reach you out through here.
Please let me know if you see they are not replying in some time