Sync Equipment Libraries
| Command Line Shortcut: sync User Permissions Level: Admin |
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.
Demystifying Synchronization
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 timestamp. 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 timestamp, yet the data is different, those records are flagged as conflict records from which you must pick the most correct.
Synchronizing Equipment Databases
The Sync Equipment Databases tool is connected to your CURRENT Equipment Library. Before a sync can occur we need to know where the OTHER database is. If it is SQL Server based check the appropriate box and enter the host login info and test the connection. If it is VISTADB the uncheck the Database is server based box and browse to the location of the OTHER WireCADGlobalEquipment.vdb3 file.
- Import - pulls data from the OTHER database into the CURRENT database.
- Export - pushes data from the CURRENT database into the OTHER database.
- Bidirectional - Employes two way synchronization making the two database identical.
