Difference between revisions of "Sync Equipment Libraries"
Wirecadadmin (Talk | contribs) |
Wirecadadmin (Talk | contribs) |
||
| Line 7: | Line 7: | ||
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. | 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. | 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. | ||
Revision as of 16:52, 21 January 2011
| 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.
