Since all of the necessary information for building the Hubs, Links and Satellites is held in the configuration, it is a simple matter to write a script, which Creates or Recreates tables as required.

Typically, this would be used in a Development or Test Environment – to reset all Hubs Links and Satellites before running a test.

Probably not something to run in Production!

 

The script is the same one that can be used to Create new Objects after building fresh Configuration.

For this case, set the @Rebuild parameter to ‘Yes’.

Optionally, set the @Release parameter to -1 if you with to be sure to recreate all objects in the Vault.

The script can be found at:

Create_Missing_Vault_Objects.sql