If you are unable to update the Data Vault by running the Data Vault Loader, you can use a staging database on which you run the updated metadata. You can then manually conduct the restore from the staging database to the existing database.
Verify that the target connection exists and that you have access to the connection.
In the Data Discovery Portal, search for the records that you want to restore.
Export the metadata associated with the records.
Run the metadata DDL on the staging database.
Run the restore job from the Data Vault to the staging database.
Alter the table in staging to synchronize with the target database schema.
Using dlink and SQL scripts, manually restore the records from the staging database to the target database.