What are the limitations for replicating stored procedure and functions?



Followings are the limitations for replicating stored procedure and functions −

  • Type of Action − Actually the replication of stored procedure and functions depends upon the type of action. If the action, embedded in stored procedures, is nondeterministic (random) or time-based then it may not replicate properly. By their very nature, randomly produced results are not predictable and cannot be exactly reproduced, and therefore, random actions replicated to a slave will not mirror those performed on a master.
  • Type of transaction − non-transactional tables for which errors occur during large DML actions (such as bulk inserts) may experience replication issues in that a master may be partially updated from DML activity, but no updates are done to the slave because of the errors that occurred.
Updated on: 2020-06-22T07:24:53+05:30

233 Views

Kickstart Your Career

Get certified by completing the course

Get Started