Yes, this is the correct process and will preserve the database, although there are some extra considerations.
In addition to the database, you will need to ensure that the encryption keys are carried over from the server configuration file, otherwise any passwords will no longer work.
Also, note that the build log database files and artifacts are stored in the server workspace folder. If you want be able to view the log and/or download artifacts for existing builds, you should copy the workspace folder to the new server. We would recommend copying the whole server share folder including the repository cache folder as it can take time to recreate the repository caches.
Here are the recommended 12 steps of server migration:
Ensure no builds are running and shutdown all Continua CI Agent services.
Shutdown the Continua CI Server service on server A.
Backup the Continua CI database.
If you are not already running the latest version:
a. Upgrade the Continua CI Server on server A to the latest version.
b. Open the Continua CI website in a browser and check that everything is working OK with the latest version.
c. Ensure no builds are running and shutdown all Continua CI Agent services.
d. Shutdown the Continua CI Server service on server A.
e. Backup the Continua CI database again (to pick up any database updates in the new version).
Copy the server share folder from server A to server B. Set it up as a share with the correct permissions (server service user needs full access, agent service users need read/write access).
Install the latest version of Continua CI server (and agent if required) on server C.
a. Ensure that you select the share that you set up in step 4.
b. Enter the connection string for the existing Continua CI database (the database will be preserved - not recreated).
After installation, shutdown the Continua CI Server service on server C (it was automatically started during installation).
Copy the following settings from
%ProgramFiles%\VSoft Technologies\ContinuaCI\Server\Continua.Server.Service.exe.config on server A to the same file on server B.
<add key="Continua.HashSalt" value="**************"/>
<add key="Continua.SymmetricEncryptionKey" value="**************"/>
<add key="Continua.SymmetricEncryptionVector" value="**************"/>
and any other settings that you may have changed on server A in the past.
Edit the configuration files for any remote agents at
%ProgramFiles%\VSoft Technologies\ContinuaCI Agent\Continua.Agent.Service.exe.config. Change the
serverPort attributes under
<endpoints> to point to the new server. Restart the agent services.
Start up the Continua CI Server service on server C.
Open the Continua CI website in a browser and check that everything is working OK.
If all is OK, uninstall the Continua CI Server on server A.
Please let us know how this works out.