Data loads and replication

To speed up the data load, you might want to turn off replication before loading operational data. Consider turning off replication if all of these statements are true:

  • You are loading large amounts of data into tables, AND
  • Those tables have triggers replicating to _all tables, AND
  • Your system is replicating those _all tables between sites, AND
  • Those _all tables reside at the local sites rather than at one master site.

In addition, there might be conflicts between data records being loaded at different sites (for example, different customers with the same number). In that case, you might want to turn off replication before loading the data, in order to minimize errors, and then deal with the conflicts later.

In the Sites/Entities form, click the Link Info tab and disable replication between sites before loading the data in these cases.

After the load is complete, enable replication and run the Manual Replication Utility for the necessary replication categories.