Changing external database settings (migrating database)

Resolution

It is not possible to:

• Alter the database settings directly in the GUI.
• Migrate to a different type of SQL database server.
  For example, migrating from Microsoft SQL to PostgreSQL is unsupported.
• Switch from an internal database to an external one.

Go through this procedure:

1. For a multi-node environment: Only keep the node that has a front-end and back-end role (and in the case of an internal database: the database role). Remove all others.
2. Create an environment backup through System Settings and download it from the appliance using SFTP.
3. Power off the remaining single node.
4. Download the same version of Parallels Secure Workspace: Download Parallels Secure Workspace appliance .
5. Go through the installation wizard and upload the environment backup. During the next steps, it's possible to adjust settings such as IP addresses, hostnames, credentials, ... . They will be prefilled, but can be altered.
6. For a multi-node environment: Don't forget to add the extra nodes again.