How to merge 2 databases question

[bswanson27]

Is there a way to merge two databases together?

Source Gear Vault Version 3.5.1

I had a power supply blow out on the server that was the host for the Vault. It took both hard drives with it. I was able to restore the Windows 2003 to another server and reload the Vault. The files were reloaded to the new machine.

The data from the blown drives was later recovered. Is there a way to merge these two databases together? Or just load in the recovered database, if we need the history of the changes?

Regards,
Bill

[lbauer]

The files were reloaded to the new machine.

Do you mean added files from your working folders to the new installation? And now you still have the database from the machine that crashed?


You can't merge the histories of the two repositories.

A couple of options:

==Do a Get Latest of all the files in your current repositories. Backup up the current production database. Then uninstall Vault and drop the database. Restore a copy of the old database.

Delete your client-side cache files, since they'll be out of sync with these older versions. Go to the path %USERPROFILE%\Local Settings\Application Data\SourceGear\Vault_1 and rename or delete the entire Vault_1 folder. You'll need to reset working folders.

Then checkout files, and replace the files in the working directories with the the latest copies that you have on your local machine, and check those in. You'll have a gap in history, but most of the history and the newest files will be there.

==Another option is to export the old repositories into a new repository on the current server. You'd need to restore a the old database to a test server, install Vault, and then do a Folder Export. The Folder Export\Import tool is in the Vault GUI Client directory. Then take that export file and import it into a new repository.

Now you will have the new files with their history and the old files in with history, though they will be in a different repository, mostly for historical reference.