Upgrade DryvIQ | SQL Server Not Installed on C:/




Summary

This documentation applies to both DryvIQ Managers and Remote Sites, as well as, clustered and non-clustered installations.

For non-clustered installations, follow the steps for the primary node only.


If the install directory was changed from the default during the original install, you must follow Option 2 below




Verify Current Version Installed

In Powershell, run the following command to see what version is currently installed prior to upgrading


Example | Default Install Directory
C:\Program Files\SkySync> .\skysync.exe --version




Step 1: Stop the DryvIQ service on secondary nodes followed by the primary node

For a Windows installation, while the installer will detect if the service is running and stop it, there may be side effects to other running nodes in a clustered environment as the primary node is upgraded. Therefore, we recommend that DryvIQ services on all secondary nodes followed by the primary node are stopped before proceeding with the upgrade.




Step 2: Run the installation executable on the primary node

The installer will detect if there is an existing DryvIQ installation and the version that is currently installed. As long as the currently installed version is older than the version being installed, the installer will continue as an upgrade. 

There are two primary options when upgrading. By default the installer will attempt to upgrade the configured database.


IMPORTANT POWERSHELL STEP

Ensure your command is for the LATEST/UPGRADE version, not the currently installed version.

.\skysync-windows-{{upgrade-version}}.exe --install-pgsql 0




Option 1: Default with Database Upgrade

Use this option if your original install used the default install configuration directory

  • By default the installer will attempt to upgrade the configured database. 


.\skysync-windows-{{upgrade-version}}.exe --install-pgsql 0




(star) Option 2 | Important Information:

  • This option should only be used in special circumstances such as the install directory is not located on the C drive
  • Make sure ALL cluster services are stopped, including the primary node that was just upgraded, before doing the database update step

Option 2: Separate Software and Database Upgrade

Ensure the installer is located in the same directory as your original install


.\skysync-windows-{{upgrade-version}}.exe --install-pgsql 0 --skip-dbupdate 1 

Once the installer successfully completes, make sure ALL cluster services are stopped, including the primary node that was just upgraded, before doing the database update step

Navigate to the installation directory in a command window and run the following command:

.\skysync.exe db update




Step 3: Run the installation executable on secondary nodes

Since the database was upgraded as part of the primary node upgrade, that portion of the upgrade can be skipped for secondary nodes. Run the following command on the remaining secondary nodes.


.\skysync-windows-{{upgrade-version}}.exe --install-pgsql 0 --skip-dbupdate 1 




Step 4: Ensure the DryvIQ services on the primary node has started. Then verify secondary nodes

Verify the services are running DryvIQ on the primary node first; start if needed. Then verify the DryvIQ services are running on the secondary nodes.




Verify Upgraded Version Installed

In Powershell, run the following command to see what version is currently installed prior to upgrading

C:\Program Files\SkySync> .\skysync.exe --version


DryvIQ Migrate Version: 5.9.1
Release Date: November 7, 2024