Search found 6 matches

by c17
Wed Feb 19, 2020 1:00 pm
Forum: Support (Vault Professional)
Topic: What should the Compatibility Level be set at?
Replies: 3
Views: 13740

Re: What should the Compatibility Level be set at?

Yes, we restored the SQL backup files from the old server to SQL S016 in the new server. When you do that, SQL Server leaves the compatibility level as per the backup file (i.e., as it was on our old server). Our question is: Has Vault (the stored procedures, etc.) been tested with and validated to ...
by c17
Wed Feb 19, 2020 12:10 pm
Forum: Support (Vault Professional)
Topic: What should the Compatibility Level be set at?
Replies: 3
Views: 13740

What should the Compatibility Level be set at?

We just moved our Vault database to a new server, running SQL 2016. Everything went fine with the move, but we noticed that the Compatibility Level for all the Vault databases is set to SQL Server 2008 (level 100). Is there a reason for this? Is it safe/advisable to move it to SQL Server 2016 (level...
by c17
Wed Jun 05, 2019 11:07 am
Forum: Support (Vault Professional)
Topic: Vault database on different server?
Replies: 5
Views: 13376

Re: Vault database on different server?

I've studied the instructions in the KB about moving Vault databases, but we want to move the databases to the Azure SQL Service. You can't backup/restore or attach/detach with that service; instead, you have to use the SSMS task "Deploy database to Azure SQL database". Would the instructi...
by c17
Tue Jun 04, 2019 2:38 pm
Forum: Support (Vault Professional)
Topic: Vault database on different server?
Replies: 5
Views: 13376

Re: Vault database on different server?

Ah, thank you. We can use SQL authentication. This is not a new installation; we already have Vault running on machine A, and we want to move just the databases to machine B. There's a FAQ detailing which databases to move, which is clear; but is there a simple way to reconfigure Vault to point to t...
by c17
Tue Jun 04, 2019 1:50 pm
Forum: Support (Vault Professional)
Topic: Vault database on different server?
Replies: 5
Views: 13376

Vault database on different server?

Is it possible to have the actual Vault database on a separate server from that hosting the Vault Web application?

That is:
Machine A (Web server only) hosts Vault server application
Machine B (SQL Server only) hosts Vault databases

If so, how is that set up?

Thanks
by c17
Wed Jan 23, 2019 5:48 pm
Forum: Support (Vault)
Topic: SQL Server Management Studio 2016
Replies: 7
Views: 12896

Re: SQL Server Management Studio 2016

Has anyone at all been able to get source control to appear and work in SSMS 17?

I've followed the instructions in the links in the posts above, but they do absolutely nothing.

Does SourceGear plan to address this major gap with an add-in?

Thanks,

C17