Forum Discussion

cguinn75's avatar
cguinn75
Level 4
16 years ago

Moving EV dbases from Sql 2000 to new server with 2005

I was wondering if anyone has any insight on moving these dbases between two servers and different sql versions.  This is admist a 6.x upgrade to 8.0 as well.   Thanks,
Database
Enterprise Vault
Information Governance
  • MichelZ's avatar
    MichelZ
    16 years ago
    By the way, just added that to the list of registry keys which might come in handy in the future: http://www.enterprisevaultfaq.com/wiki/EV_Registry_Settings_(Index) ;)
Liam_Finn1's avatar
Liam_Finn1
Level 6
16 years ago

Sorry

 

I made the assumption that the new server would have the same name as the old server

 

Actually keeping the server names the same makes life so much easier

 

If you want to modify the server name then you need to make changes in the EnterpriseVault Directory database

 

In the table VaultStoreEntry there is a field called SQLServer. You need to update this field to the name of the new SQL server. You will need to do this for every vault which will have it's database moved to the new server

 

As always please remember to back everything up before making any such changes.