Vault 5.0 downgrade to 4.1.4

[cknox]

Is there a way to do this? I'm wanting to upgrade to the 5.0 release, but one of our requirements before any major upgrade is to have a backout plan. Right now my thoughts are to backup the sgvault and sgmaster DBs, and if there's an issue uninstall 5.0.0, then reinstall 4.1.4 and restore the DBs. Would this work? Also if we're using SQL Server Express, is there a way to automate the backup of the database (ie can we set it to backup the databases every day?)

[lbauer]

You can go back to your previous Vault 4.1.4 database, but you can't downgrade a 5.0 database to version 4.

Right now my thoughts are to backup the sgvault and sgmaster DBs, and if there's an issue uninstall 5.0.0, then reinstall 4.1.4 and restore the DBs. Would this work?

This would work, but any changes made in the 5.0 database would be lost.

If you want to try a 5.0, we would suggest doing this on a test server. To restore your 4.1.4 database to a test SQL Server, upgrade to Vault 5.0, and test things out before upgrading your production server.

Code: Select all

Also if we're using SQL Server Express, is there a way to automate the backup of the database 

Although standard SQL Server has options for automated backup in the maintenance plans, from what I see on the Internet, SQL express does not. However you can do automated backups via a script.

See these links for more information:
http://www.fmsinc.com/freE/NewTips/SQL/ ... Backup.asp
http://www.brianmadden.com/blogs/guestb ... store.aspx