When we get ready to upgrade to a new version of Inventor, the first thing we need to do is upgrade our Vault for testing purposes. I am not ready to do the actual upgrade, but want a test environment. There are other SQL based products that allow you to clone your production server and then go into SQL and update the tables to look at the new cloned server instead of the original server. With the ADMS installation, I am told that this cannot be done. So instead I have to have our IT department create a brand new server with SQL on it and then do a restore from our production server. While that sounds easy to accomplish, it never seems to be in reality. The first time they tried it, the IT department didn't get all of the correct SQL versions installed and although I was able to install the ADMS, when I tried to restore, it gave me an error saying they were not compatible. After messing around with it for days, he finally started from scratch again and was able to get me something that worked but this entire process took me two weeks to get accomplished. That is not acceptable. With our other SQL product, it is accomplished in less than a day which includes them creating a clone of the server, and I manipulating the tables to no longer read the original server, but rather the new clone name.
Show More