docs.particular.net icon indicating copy to clipboard operation
docs.particular.net copied to clipboard

Improve the documentation for how to migrate data between ServiceControl instances

Open timbussmann opened this issue 4 years ago • 2 comments

Relevant information

When migrating a ServiceControl instance to a new server or system, it's not obvious how to transfer the data of the existing SC instance to the new SC instance. It seems that the only approach at the moment seems to just copy the whole database (or create a backup in maintenance mode) (see https://docs.particular.net/servicecontrol/backup-sc-database#important-notes-and-restrictions) which seems to be a brittle approach, as according to our documentation, the instances need to have the same service name (which might not be desired by the user):

When restoring a ServiceControl database, the name of the ServiceControl Windows Service must be the same on the target machine as it was on the source machine.

timbussmann avatar Dec 04 '20 17:12 timbussmann

There's not much we can do without tying ourselves more the either Esent or Raven.

We can spend some time improving the documentation (perhaps having a dedicated "migrating data" section) on exporting/importing to try make the process clearer - possibly even include some powershell scripts.

WilliamBZA avatar Dec 07 '20 09:12 WilliamBZA

We have guidannce for performing a zero-downtime upgrade which could be extracted and repurposed.

mikeminutillo avatar Mar 09 '23 09:03 mikeminutillo