SQL Server 2012 Support

If you are having a problem using Vault, post a message here.
Post Reply
JamesGreen
Posts: 11
Joined: Thu Jun 09, 2011 3:01 am
Location: Sydney, Australia

SQL Server 2012 Support

Post by JamesGreen » Mon May 07, 2012 1:03 am

Hi guys,

Long time fan of Vault (standard) and I was just starting to evaluate Vault Pro with the current eval version (5.1.2).

The server environment I would like to deploy Vault Pro into is running SQL Server 2012 (this will end up on Express Edition in case that matters).

To set up our test environment I started with a clone of our current Vault Pro databases and ran the server installation MSI package.

The installation failed because the sp_dboption stored proc is being called by the installer, and it is deprecated in SQL Server 2012.

Is it possible to install Vault Pro on SQL Server 2012 at the moment?

Thanks in advance
James

lbauer
Posts: 9736
Joined: Tue Dec 16, 2003 1:25 pm
Location: SourceGear

Re: SQL Server 2012 Support

Post by lbauer » Mon May 07, 2012 8:38 am

Full support for SQL Server 2012 will come in Vault 6.0, due out later this year.

We've done a few tests wtih SQL Server 2012 and Vault 5.1.2, but didn't run into the problem you reported.

Could you tell us the specific steps you followed so we can try to reproduce them here?

What Vault version are your current databases, and what version of SQL Server have they been on?

What OS are you using for Vault/SQL Server?
Linda Bauer
SourceGear
Technical Support Manager

lbauer
Posts: 9736
Joined: Tue Dec 16, 2003 1:25 pm
Location: SourceGear

Re: SQL Server 2012 Support

Post by lbauer » Mon May 07, 2012 8:50 am

I think when I tested it I did a fresh install, so it's possible it's the upgrade that isn't working.
Linda Bauer
SourceGear
Technical Support Manager

lbauer
Posts: 9736
Joined: Tue Dec 16, 2003 1:25 pm
Location: SourceGear

Re: SQL Server 2012 Support

Post by lbauer » Mon May 07, 2012 10:47 am

I was able to reproduce the error when I ran the installer to upgrade an existing Vault database in SQL Server 2012. I'll log a bug.

We will fully support SQL Server 2012 in Vault 6.
Linda Bauer
SourceGear
Technical Support Manager

JamesGreen
Posts: 11
Joined: Thu Jun 09, 2011 3:01 am
Location: Sydney, Australia

Re: SQL Server 2012 Support

Post by JamesGreen » Tue May 08, 2012 1:33 am

Thanks for the quick reply guys.

Our production Vault environment is on SQL Sever Standard 2008 RTM (v10.0.1600.22) and Vault 5.1.0. It was a clone of these databases I restored for my SQL Server 2012 test box.

I have installed SQL Server 2008 R2 Express Edition on my testing server and the Vault Pro setup completed without a hitch.

Thanks for your help
James

lbauer
Posts: 9736
Joined: Tue Dec 16, 2003 1:25 pm
Location: SourceGear

Re: SQL Server 2012 Support

Post by lbauer » Tue May 08, 2012 9:41 am

Thanks for the update.
Linda Bauer
SourceGear
Technical Support Manager

Post Reply