My Octopus Deploy at present point to the Octopus database on Microsoft SQL database 2008.
I would like to move the Octopus database on Microsoft SQL database 2014.
Can I amend Octopus Deploy to reference the Octopus database on Microsoft SQL database 2014 or Do I have to reinstall Octopus Deploy?
Thanks for reaching out. If all you are doing is moving the database, but the Octopus Server is staying in the same place, then you can just update the connection string in the OctopusServer.config file (in C:\Octopus by default).
The line you gotta update looks like this:
<set key="Octopus.Storage.ExternalDatabaseConnectionString">Data Source=NY-DB1\NYDB1;Initial Catalog=Octopus1;Integrated Security=True</set>
Also make sure that the database allows connections to the service account that’s currently running the Octopus Server service.