Setting load order
You can set the load order for each of the selected tables. This may be useful, for example, if your selected tables list contains tables of different sizes and you want the smaller tables to be loaded before the larger tables. When a group of tables are set with the same load order, Replicate will load the tables according to the table ID.
Load order can be set and modified (see note below) in the following places:
- The Select Tables window (opened in Designer view by clicking the Table Selection button in the right of the console).
- The Patterns and Selected Tables list in the right of the console (in Designer view).
Information note
To set the load order for a specific table:
-
Select the desired table in the Selected Tables list.
- From the Load Order drop-down list, select one of the available priority levels (Lowest Priority, Low Priority, Normal Priority, High Priority, and Highest Priority).
- This step is only relevant if you are setting load order in the Select Tables window. Click OK to save your settings and close the Select Tables window.
To set the same load order for multiple tables:
-
Select the desired tables in the Selected Tables list.
- From any of the selected items' Load Order drop-down list, select one of the available priority levels.
- This step is only relevant if you are setting load order in the Select Tables window. Click OK to save your settings and close the Select Tables window.