We’re moving our Octopus server to AWS (we don’t plan on using hosted Octopus) with the database running on AWS RDS. When installing, i’m getting this error:
SQLException has occured in statement #0 of this TSQL script: ‘Octopus.Core.UpgradeScriptsPre.Script0000 - Database options.sql’; Line: 1; Procedure: ; Error Number: 1468; Excerpt: ‘-- This script cannot run inside a transaction https://technet.microsoft.com/en-us/library/ms191544(v=sql.105).aspx’; Message: The operation cannot be performed on database “myDb” because it is involved in a database mirroring session or an availability group. Some operations are not allowed on a database that is participating in a database mirroring session or in an availability group.
I’m pretty sure there’s no way on RDS to temporarily break the mirroring for a single db. Is there any way for me to make this work? Can I execute the upgrade scripts manually outside of a transaction, for instance?