topic Re: Upgrade path SQL Vault in Vault Forum

Upgrade path SQL Vault

johan.degreef — Thu, 14 Jul 2022 14:35:59 GMT

We are on Vault Pro 2022.3, SQL 2019 Express CU8

Should we first upgrade SQL to CU13 and then Vault 2022 to 2023

Should we first upgrade Vault 2022 to 2023 and then SQL to CU13?

and should I upgrade SQL first to CU9, CU10, CU12 and then to CU13, or directly from CU8 to CU13

Re: Upgrade path SQL Vault

ihayesjr — Thu, 14 Jul 2022 16:32:37 GMT

@johan.degreef wrote:

We are on Vault Pro 2022.3, SQL 2019 Express CU8

Should we first upgrade SQL to CU13 and then Vault 2022 to 2023

Should we first upgrade Vault 2022 to 2023 and then SQL to CU13?

It doesn't matter which of these you decide to do first as long as you end up in the supported 2023 environment.

@johan.degreef wrote:

and should I upgrade SQL first to CU9, CU10, CU12 and then to CU13, or directly from CU8 to CU13

"CU" stands for Cumulative Update, which means that all previous updates are in the current update.

It is not necessary to install the middle updates. Just install CU13.

Re: Upgrade path SQL Vault

johan.degreef — Sun, 17 Jul 2022 09:38:44 GMT

To upgrade our 2022 Vault server is it OK to install "VPS2023_ENU_64bit_dlm_001_002.sfx.exe" over an existing Vault 2022 server?

Re: Upgrade path SQL Vault

ihayesjr — Sun, 17 Jul 2022 17:30:49 GMT

@johan.degreef

That is the standard upgrade path. Please review the section where you found that chart.

Re: Upgrade path SQL Vault

johan.degreef — Mon, 18 Jul 2022 04:35:34 GMT

@ihayesjr

Does underneath means, 1st install 2023 and then 2023.1 and at last migrate databases?

https://knowledge.autodesk.com/support/vault-products/learn-explore/caas/CloudHelp/cloudhelp/2023/ENU/Vault-Install/files/GUID-E1B454DA-7967-48B7-BFDB-AE2A028E31B9-htm.html

Install Current Vault Server

Installing Vault server 2011 or a newer release supports automatic uninstall of Vault server 2010 or newer. Therefore, it is not necessary to uninstall Vault 2010 or a newer release.

During every installation of Vault server, enable the option to download and apply Service Packs.

At the end of the installation, you are prompted to start the Vault server application and migrate the Vaults. Do not migrate the vaults at this time.

Apply Hot Fixes (are these the dotted upgrades like 2023.1?)

All hotfixes created after the final Service Pack should be manually installed at each site. Installing the hot fixes ensures that the latest updates are applied for proper migration.

Migrate Vaults

When Vault Server first launches, the administrator is prompted to migrate the vault and library databases. Users are not able to log into a vault until migration is complete. Do not migrate until all service packs and hot fixes have been applied.

If a service pack or hotfix is applied after migration, a build-to-build (b2b) migration is required. B2B migration is a command line option detailed in the section Migration Timeout and on the Autodesk Wiki.

Re: Upgrade path SQL Vault

ihayesjr — Mon, 18 Jul 2022 12:57:51 GMT

You can do it that way.