Vault Downgrade MS SQL Database

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

Moderator: SourceGear

Post Reply
cpede
Posts: 5
Joined: Fri Aug 16, 2013 2:34 am

Vault Downgrade MS SQL Database

Post by cpede » Fri Jun 08, 2018 4:07 am

How do I downgrade from one MS SQL Express 2018 database to a standard MS SQL 2005 database with Vault?

It seems that the Vault Backup/Restore rely on the build-in SQL backup/restore and therefore comes in trouble when downgrading?

-cpede
-cpede
(Vault Standard 10.0.1.793)

Tonya
Posts: 495
Joined: Thu Jan 20, 2005 1:47 pm
Location: SourceGear

Re: Vault Downgrade MS SQL Database

Post by Tonya » Fri Jun 08, 2018 8:56 am

You would need to downgrade your database from within SQL to use an older SQL Server version. I don't believe that Microsoft supports this but I was able to locate some information online from miscellaneous websites. You would need to obtain a backup of your Vault database, perform the downgrade from within SQL Server and then restore your database back into Vault.

Thanks,

Tonya

Post Reply