While using Autodesk Vault, you may encounter the need to move your data from one server to another. Some of the reasons to move to another server could be due to hardware replacement, upgrades, or the wish to create a test environment with a copy of your production data. There are two supported methods to migrate your Autodesk Vault and its data to a new server:
Performing a Vault Backup and Restore and using the ADMS Detach and Attach command. Here we detail the ADMS tool, for details on using Backup and Restore, see (Part 1 ADMS Backup and Restore)
Is the ADMS Detach and Attach the right direction for your organization?
Pros: ADMS Detach and Attach creates all SQL permissions and migrates the databases to the proper version. You can copy the filestore, .mdf (data files) and .ldf (log files) directly to their final destinations on the new server. Subsequently, this method requires less downtime. Using Detach and Attach is faster than a backup and restore.
Cons: Using this method will delete user associations to individual vaults – if you have created user associations to the vaults by the user, you will need to re-assign those users to their respective vaults, whereas if you have created them by the group, you will need to re-assign the groups to the vaults. You are responsible to separately backup/copy each filestore, .mdf and .ldf to the new server.
For full details, view the complete post on our new Vault blog here
Traci Peurasaari
Autodesk SQL DBA / Specialist
Comments