You can replicate file stores from one site to another site. This process is managed by one Microsoft SQL database. The configuration used in replication is known as a workgroup. The following illustration shows a typical workgroup configuration. All sites in a single workgroup share the same Microsoft SQL server.
To allow sites to have their own database server to increase SQL performance, Vault uses connected workgroups. The following illustration shows a workgroup with two different sites connected to a second workgroup with a single site.
Release Availability
The connected workgroups feature is available in certain editions of Vault. Refer to the following table to see if your edition supports this feature.
| 2012 | 2013 | 2014 | |
|---|---|---|---|
| Autodesk Vault Basic |
|
||
| Autodesk Vault Workgroup |
|
||
| Autodesk Vault Collaboration |
|
|
|
| Autodesk Vault Professional |
|
|
|
Add a Workgroup
Before adding a subscribing Workgroup a supported version of Microsoft SQL Server must be installed on the Subscribing server.
- Install Microsoft SQL with an instance named AUTODESKVAULT on the subscribing server.
- Launch the Vault server console from the publishing server.
- Right-click the workgroups node and select Add Workgroup.
- In the Add Workgroup dialog enter the required information.
- Click OK.
- Workgroup Name - The name of the new workgroup.
- Workgroup Label - The unique name for the new workgroup. This name will be tied to all schemes created for this workgroup.
- Subscriber Server Name - The name of the server with SQL installed for the new workgroup.
- Remote SQL Credentials - The login credentials for the new SQL server being used for the new workgroup.
- Remote Replication Credentials - The credentials set up for replication when defined when configuring the publishing server.
Delete a Workgroup
A workgroup that is no longer needed can be deleted. A workgroup can be deleted using the server console from the publisher workgroup.
- In the navigation pane, select Workgroups.
- Right-click a workgroup in the list and select Delete Workgroup.
- When prompted for confirmation to delete the workgroup click yes.
- If an error occurs where the subscriber database cannot be cleaned up, repeat the process but select Unconditional delete.
Edit Workgroup Name or Label
You can change the workgroup name or label by accessing the workgroup properties.
- In the navigation pane, select Workgroups.
- Right-click a workgroup in the list and select Properties.
- Enter the new workgroup name and label.
- Click OK.
- Workgroup Name - Name of the workgroup seen in the navigation pane.
- Workgroup Label - Unique name for the workgroup used by the Vault server.