User Tools

Site Tools


en:advancedreplication

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

en:advancedreplication [2017/04/14 21:55] (current)
Line 1: Line 1:
 +TitleEngTAG ​
  
 +
 +
 +<​HTML><​H3>​Advanced Replication Functionality</​H3></​HTML>​
 +
 +The menus HOME and ACTIONS of Export Data Distribution Setup show the Advanced Replicaton tools:
 +
 +{{ AdvancedReplication.png }}
 +
 +These tools are provided to replicate in a massive way an entire table (or a subset of records, if used with the specific filter), so they are used mostly for the initial synchronization of a database.
 +
 +We have three Actions groups: ​
 +
 +**Replicate - All fields** This group operates only over the actually selected table: any button send the specific operation (INSERT, MODIFY or INSERT + MODIFY) for every record of the table. The operation INSERT + MODIFY is user to copy safely the entire table, because the INSERT operation will fail if the corresponding record already exists on the target database. If the //Advanced Replication Filter// is set, it overwhelms the //Table Export Filter//; if not, the //Table Export Filter// is honored.
 +
 +**Replicate - Only configured** This group differs from the previous: only the fields set up accordingly in the Export Setup are replicated.
 +
 +**Replicate - ALL TABLES** The operation INSERT, MODIFY or INSERT + MODIFY are reported for any record (according to filters) for every table having a configuration set for //Report Insert// or //Report Modify//. The filter //Advanced Replication Filter// is normally not used in this case, because this filter can not be applied on every table.
 +
 +__WARNING__:​ these massive operations could generate many import errors: for example for an INSERT when the record already exists. Anyway a MODIFY will fail if the record doesn'​t exists: so the correct strategy to duplicate a table is to apply INSERT + MODIFY, despite to the errors. The replication will not delete a target record not existing in the source database. ​
 +
 +The Action **Configuration Export** is not active in this version.
en/advancedreplication.txt ยท Last modified: 2017/04/14 21:55 (external edit)