New subjob From Table Designs Dialog

General setup > Replication > Subjobs > Add multiple subjobs

What is the dialog used for?

  • To add subjobs for multiple tables at the same time. All the subjobs will have the same replication method.
Fields & buttons Description
A tree of database designs and tables Select a Database design or just the tables to create subjobs for.
Replication method

Select one of the three types of replication methods:

  • Normal - The contents of a database table are replicated as a whole. Normal subjobs are suitable for small tables or cases where entire tables must be replicated like when preloading a new store or a POS. Normal subjobs also support replication counters, where a unique index exists that can be used to select records to be replicated. This is useful when replicating transactions from POS, so only the newest records will be replicated.
  • Action - The contents of a database table are replicated by reading a second table, the action table. The action table determines which rows in the main database table have changed and how. Action subjobs are suitable for large tables when you want to minimize data flow by replicating only the changes made in the source location.
  • Stored Procedure - An action table is read on the source location and for each suitable entry in the action table, a stored procedure is run on the destination locations. Stored procedure subjobs are suitable for replicating business logic transactions implemented through stored procedures.
Subjob description prefix Enter a prefix that will be added in front of the table name in the subjob's description. For an example in the demo data all normal jobs have the prefix N- and all action jobs have the prefix A-.

See also

Last updated: 12th May 2013
Version: LS One 2013.1