SQL 2014 Upgrade

If you are having a problem using Vault, post a message here.

Moderator: SourceGear

Post Reply
Clyde
Posts: 3
Joined: Tue Oct 14, 2014 4:17 pm

SQL 2014 Upgrade

Post by Clyde » Tue Oct 14, 2014 4:24 pm

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
Posts: 8550
Joined: Wed Jun 21, 2006 8:24 pm
Location: SourceGear
Contact:

Re: SQL 2014 Upgrade

Post by Beth » Wed Oct 15, 2014 9:12 am

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.
Beth Kieler
SourceGear Technical Support

Clyde
Posts: 3
Joined: Tue Oct 14, 2014 4:17 pm

Re: SQL 2014 Upgrade

Post by Clyde » Wed Oct 15, 2014 11:04 am

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
Posts: 8550
Joined: Wed Jun 21, 2006 8:24 pm
Location: SourceGear
Contact:

Re: SQL 2014 Upgrade

Post by Beth » Wed Oct 15, 2014 1:34 pm

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.
Beth Kieler
SourceGear Technical Support

Neil Weicher
Posts: 38
Joined: Thu Apr 01, 2004 7:14 am
Location: Stamford, CT
Contact:

Re: SQL 2014 Upgrade

Post by Neil Weicher » Mon Dec 29, 2014 7:00 am

Beth wrote: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
Posts: 8550
Joined: Wed Jun 21, 2006 8:24 pm
Location: SourceGear
Contact:

Re: SQL 2014 Upgrade

Post by Beth » Mon Dec 29, 2014 1:55 pm

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.
Beth Kieler
SourceGear Technical Support

Clyde
Posts: 3
Joined: Tue Oct 14, 2014 4:17 pm

Re: SQL 2014 Upgrade

Post by Clyde » Thu May 28, 2015 3:27 pm

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

Beth
Posts: 8550
Joined: Wed Jun 21, 2006 8:24 pm
Location: SourceGear
Contact:

Re: SQL 2014 Upgrade

Post by Beth » Thu May 28, 2015 3:31 pm

Thank you for the update.
Beth Kieler
SourceGear Technical Support

Post Reply