|
<< Click to Display Table of Contents >> Synchronizing with Another Equipment Database |
  
|
|
<< Click to Display Table of Contents >> Synchronizing with Another Equipment Database |
|
Menu: Database>Synchronize Global Database ...
Default command line shortcut: sync
Related Settings:
None
Occasionally you may experience the need to sync with another user's global database. This will copy all of their equipment to your Global Equipment Database. The sync includes manufacturers, equipment, inputs, outputs, signal types, connectors, cable types, cable core data, relational tables, etc.
You may choose within the tool to perform an import, export or bidirectional sync.
Synchronizing data in two tables of the same structure is really very simple. In its most basic form, records that do not exist in one table are added. Records that exist in both tables receive the most current data based on a time stamp. In order that records deleted from one table do not get added back in, a special table is employed to track deleted keys. If the delete is the most current action then the record will likewise be deleted from the other table. In the unlikely event that the records have the exact same time stamp, yet the data is different, those records are flagged as conflict records from which you must pick the most correct.
Controls
Basic tab
Advanced tab
•Database Location - Select either a VistaDB file based database or a SQL Server host. If server based you will need to provide host and credentials. If you do not know them contact your SQL Server database administrator.
•Import, Export, Bidirectional - Sync direction. Our current global database is the reference. An Import will import records into our current global database.
•Remember Settings - Remember database location information.
•Sync - Initiates the synchronization with the top progress bar showing the overall progress and the bottom showing detail progress.
•Status Bar - Displays status of the sync.
•Advanced Tab - Select the collections to be synchronized.