How move access database

Document ID : KB000092951
Last Modified Date : 11/06/2018
Show Technical Document Details
Introduction:
The current database of vantage it is installed on a server.This data base is used by all VANTAGE WINDOWS clients. 
How this data base should be moved to another server continuing to be a common data base ? 

 
Instructions:

The official way to create a shared central database is described in the documentation here under the "Central Database" subtitle (https://docops.ca.com/ca-vantage-storage-resource-manager/14-0/en/windows-client/customization#Customization-CentralDatabase). 

WC Export and Import functionality is meant for extracting resp. adding specific user objects (user-views, consoles, hosts etc) from resp. to an existing WC database. If customer wants to share an existing WC database among several WC instances, they do not need either export or import the database. 

In order to create a central database shared among several WC instances: 
1) Create a network share (\\czprfs51\CA-Storage_Dev\zacra01 in attached screenshots "Central DB Location.png" and "Installation Settings Summary .png") 
2) Install all WC instances which are to share a central database 
3) During each WC installation refer in step "Choose Central Database Location" (see attached "Central DB Location.png") to the the network share created in the point 1. 
4) After installing all WC instances as described in points 2 and 3, copy content of the central database (typically BrightStor SRM Data\Central) to the network share. 

So in other words, install on one VMWARE the new Gui from scratch pointing to the new server database location. Then install the second Gui on the other VMWARE pointing to the first server database address. 

After starting the Gui once on each VMWARE and verifying it works fine, then stop it and copy the actual database directory (C:\BrightStor SRM Data) to replace it on the new location. 


The GUI version installed on the new VMWARE should be the exact same version which is actually running.