When the admin set up PDMLink here, he configured it to use multiple vaults. We have vaults for Product parts, Library parts and Library documents and a couple of others. Moving forward, we are planning on converting from Oracle to SQLServer when we upgrade to WC10.
In our environment, single site, secured network, single product, is there an advantage to using multiple vaults? I haven't seen one and converting over would eliminate the headache of vaulting rules that we now have. I have no need to track disk storage space or segregate classified data.
I have seen the instructions in the System Administrator's Guide on how to convert from multiple vaults to a single vault. They look straight forward enough, though it may take time with over 1.25 million files in our vaults.
Should I: 1) continue as we are, or 2) convert to a single vault? Opinions and reasoning would be appreciated. If I get enough replies I will summarize.
I think the argument for multiple vaults is the MTR or Mean Time to Recovery. If the admin only needs to recover a smaller vault then the system will be back up and running much faster versus recovering a single large vault.
Patrick Williams | Engineering Systems | o: 616.698.3766 | c: 616.947.2110 [cid:image001.jpg@01CCE0C8.29C2E020]
A good business reason to store data in separate vaults is to easily be able to spin off a business unit. This can be configured per product. We are also using this for remote mastering and predictive replication, new in 9.1. TRW has offices around the world and not all have excellent network connections. To enable around the sun development same servers also have replica vaults. Our cluster is not the only home to data. No reason to store it there.