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
Upgrade Vault from 5.1.1 (19215) to 7.0
Moderator: SourceGear
Re: Upgrade Vault from 5.1.1 (19215) to 7.0
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'
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'
Re: Upgrade Vault from 5.1.1 (19215) to 7.0
You will also want to check out our Upgrading Guide prior to upgrading.
Here are two ways to see what version you are using.
I will need to double check on the custom code you have and will post back.
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 will need to double check on the custom code you have and will post back.
Beth Kieler
SourceGear Technical Support
SourceGear Technical Support
Re: Upgrade Vault from 5.1.1 (19215) to 7.0
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
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
Re: Upgrade Vault from 5.1.1 (19215) to 7.0
Nothing has changed in the areas that your SQL query is accessing. Your query should still work fine.
Beth Kieler
SourceGear Technical Support
SourceGear Technical Support
Re: Upgrade Vault from 5.1.1 (19215) to 7.0
Thanks Beth
Re: Upgrade Vault from 5.1.1 (19215) to 7.0
You're welcome.
Beth Kieler
SourceGear Technical Support
SourceGear Technical Support