SQL 2014 Upgrade

[Clyde]

What is the recommended upgrade path in this scenario

Vault Standard 5.1.1 on Windows Server 2003/SQL2000 on same machine
to
Vault Standard 7.2.1 on a new Windows 2012 Server, SQL 2014 on a separate server

According to the compatibility matrix, it appears the existing server cannot be upgraded to Vault 6.# because of SQL2000, nor can v6.# be installed on the new machine because of SQL 2014

Can the upgrade be made from 5.1.1 directly to 7.2.1? THX

[Beth]

Another issue you are going to have is that SQL Server can't make the leap between a SQL 2000 database and a SQL 2014 database. The database even without Vault can't make that leap.

What is the size of your database? It might be possible to run it through an upgrade using a SQL Express version that SQL will support the upgrade through.

[Clyde]

Current db size is around 85GB

I have a SQL 2005 and a SQL 2008 instance available, but not sure how to take to leverage that. THX

[Beth]

Here's the route I would recommend.

• 1) Backup your sgvault and sgmaster databases, and restore them on either the SQL 2005 or SQL 2008 server.
  2) If there is IIS on the server, or on some other supported machine, run the Vault 6.1.0 installer there and allow it to connect to the restored database to upgrade it.
  3) Uninstall the install you performed in Step 2, but choose the option to keep the database. (steps 3 and 4 can be interchanged.)
  4) Backup your sgvault and sgmaster databases and restore them to the SQL 2014 server.
  5) Install Vault 7.2.1 and point it to the SQL 2014 server and allow it to upgrade the database.

[Neil Weicher]

Here's the route I would recommend

.

We will also be upgrading from Vault Pro 5.11 on Windows 2003 / SQL 2000 to Vault Pro 7. We will be upgrading to Windows 2008 Server / SQL 2008.

It sounds like Vault Pro 7 will not automatically import/update the SQL 2000 databases from Vault Pro 5.11?

Does that mean we have to obtain and install Vault Pro 6 as an interim step? Or is there a utility that will upgrade the database without having to go through the Pro 6 step?

Thanks.

[Beth]

I've responded via email to your questions. You will go through the Vault 6 Pro step, but after you move to your new server. You don't need licenses or to even test it. Just use it to upgrade the database.

[Clyde]

We were able to upgrade using your recommendation with no issues. We were then able to upgrade to 8.01. Thanks

[Beth]

Thank you for the update.