Migration of Octopus onto a new server

[chris.banthorpe]

Hello,

We’ve got an Octopus server running multiple instances of Octopus and want to migrate it to another server.

Could you please outline the steps that need to be undertaken as I can’t see documentation for multiple instance migrations in your documentation?

[Alex.Rolley]

Hi @Chris
Thanks for getting in touch!

Sorry that this one is more difficult than it should be, it seems we don’t have a way to specify an instance using our command line tools. What I would recommend in this case is following our moving your Octopus Server and Database documentation, then when you need to update your SQL connection string to do a manual update of the config files.

To do that you will need to stop the appropriate Octopus server service, update the database connection string Octopus.Storage.ExternalDatabaseConnectionString in your OctopusServer.config (or OctopusServer-INSTANCE.config) file. I’ve included an extract from an example file below:

<?xml version="1.0" encoding="utf-8"?>
<octopus-settings xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
  <set key="Octopus.Communications.ServicesPort">10943</set>
  <set key="Octopus.Home">C:\Octopus</set>
  <set key="Octopus.Server.NodeName">OctoNode1</set>
  <set key="Octopus.Storage.ExternalDatabaseConnectionString">Data Source=(local)\SQLEXPRESS;Initial Catalog=Octopus;Integrated Security=True</set>
  <set key="Octopus.Storage.MasterKey">EncodedMasterKey</set>
  <set key="Octopus.Upgrades.AllowChecking">true</set>
  <set key="Octopus.Upgrades.IncludeStatistics">false</set>
  <set key="Octopus.WebPortal.ForceSsl">false</set>
  <set key="Octopus.WebPortal.ListenPrefixes">http://localhost:80/</set>
</octopus-settings>

Once that line has been updated restart your Octopus Server service and it will attempt to connect to the new database.

Let me know if you run into any issues or if there is anything else that I can help you with,

Regards,
Alex