What is the purpose of Rule Type "Move"?

Answered

Immanuel Michael

• April 01, 2020 06:42

Hi,

I noticed we have a rule type "Move". Can someone help understand the purpose of this rule type and also an example of usage & query?

Regards,

Immanuel

0

• Best answer

  

  Ben Bauer

  • April 01, 2020 11:28

  Hi Immanuel,

  The idea behind a "Move" rule is that it is essentially an "Insert" rule that adds rows to any table other than the Target Table. 
  This rule type is optional (and mostly deprecated), because you can achieve the same functionality with an "Insert" rule or a "Manual" rule. I think some just find the "Move" rule type easier to quickly audit visually when there are multiple types of inserts being performed by a set of rules.

  However, it is important to note that the 'Build Rule' button in Transform can only be used on "Delete", "Insert", & "Update" rules. For "Move" rules, you have to build the view and stored proc yourself, just like "Manual" rules.

  • A "Move" rule view must end in "MovSel".
  • A "Move" rule stored proc must end in "Mov".
  • You should model them after the autogenerated view and stored proc for "Insert" rules, though technically they can perform any action (just like "Manual").

  Thanks,

  Ben

  3
• 

  Immanuel Michael

  • April 01, 2020 13:07

  Thank you Ben.

  0

Please sign in to leave a comment.