Syncronizing a self reference table
Posted in 2016
Topics: General Discussion
Hi, I synchronized all the tables except one of a database without any problem, but this table has a self reference constraint. My question is, must I first disable all constraints off from the target table, before use the "cdr sync" command ? Or what I need to do to synchronize this table ? Thanks in advance.
Use 'cdr check'. It will run through the referential chain and sync that unit as a single transaction using deferred constraint checking. cdr sync will use a sequential can, and will not run through the referential chain. Madison Pruet Retired and Loving it On Friday, June 24, 2016 2:15 PM, Jorge Valenzuela <jorgervt@gmail.com> wrote: Hi, I synchronized all the tables except one of a database without any problem, but this table has a self reference constraint. My question is, must I first disable all constraints off from the target table, before use the "cdr sync" command ? Or what I need to do to synchronize this table ? Thanks in advance. ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.