Upgrade Vault from 5.1.1 (19215) to 7.0

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

Moderator: SourceGear

Post Reply
btd
Posts: 324
Joined: Fri May 13, 2005 1:50 pm

Upgrade Vault from 5.1.1 (19215) to 7.0

Post by btd » Mon Oct 07, 2013 6:51 am

We wish to upgrade our Vault from 5.1.1 to 7.0.

I see this link
http://support.sourcegear.com/viewtopic ... 13&t=19341


But how do I know what version of Vault I have and what account do you have on file for me to download version 7?


Thanks

btd
Federal Home loan Bank of Cincinnati

btd
Posts: 324
Joined: Fri May 13, 2005 1:50 pm

Re: Upgrade Vault from 5.1.1 (19215) to 7.0

Post by btd » Mon Oct 07, 2013 7:09 am

I also have this custom code that I wrote that is used as the source for a Reporting Services report.

Will this change with the upgrade?

USE sgvault
SELECT
r.name AS 'Repository Name',
c.fullpath,
c.lockwhen,
u.login AS 'User Name',
u.email
FROM
tblcheckoutlistitems AS c
INNER JOIN tblrepositories AS r ON c.repid = r.repid
INNER JOIN sgmaster.dbo.users AS u ON u.userid = c.userid
WHERE r.name NOT LIKE '%sandbox%'

GROUP BY
r.name,
u.login,
c.fullpath,
c.lockwhen,
u.email
ORDER BY
'Repository Name',
c.lockwhen DESC,
'User Name'

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

Re: Upgrade Vault from 5.1.1 (19215) to 7.0

Post by Beth » Mon Oct 07, 2013 3:27 pm

You will also want to check out our Upgrading Guide prior to upgrading.

Here are two ways to see what version you are using.
  • 1) Open a Vault GUI client, login, then go to Help - Technical Support. It will tell you both the version of your client and the server and additional details about the environment.
    2) Open a browser and go to http://<your Vault server>/vaultservice/index.html. That will tell you the server version.
I see your account under the company's email address. I can send you a direct link to it if you send me an email. The email is support at sourcegear.com. Or just provide your official company address when logging into the CSP and it should take you directly to the account.

I will need to double check on the custom code you have and will post back.
Beth Kieler
SourceGear Technical Support

btd
Posts: 324
Joined: Fri May 13, 2005 1:50 pm

Re: Upgrade Vault from 5.1.1 (19215) to 7.0

Post by btd » Tue Oct 08, 2013 4:51 am

Beth:

I sent you at email to support@sourcegear.com.

Also, let me know about my SQL and Reporting Services report if it will work after I upgrade to 7.0.

Thanks

Tom

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

Re: Upgrade Vault from 5.1.1 (19215) to 7.0

Post by Beth » Tue Oct 08, 2013 8:18 am

Nothing has changed in the areas that your SQL query is accessing. Your query should still work fine.
Beth Kieler
SourceGear Technical Support

btd
Posts: 324
Joined: Fri May 13, 2005 1:50 pm

Re: Upgrade Vault from 5.1.1 (19215) to 7.0

Post by btd » Wed Oct 09, 2013 8:23 am

Thanks Beth

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

Re: Upgrade Vault from 5.1.1 (19215) to 7.0

Post by Beth » Wed Oct 09, 2013 8:35 am

You're welcome.
Beth Kieler
SourceGear Technical Support

Post Reply