hello there,
I'm replicating branch databases into HQ, so for all articles I left default options. Then when I checked in subscriber the table structure I saw that referencial intergrity is not reflected (no primary key and foreign keys !!!), only indexes are created. So what I should do is to go in the options for eacch article (table) --> snapshot tab - enable "Include declared referential integrity". Is there possible automatically for all published tables to enable this option, because I have 286 tables!!!
And can I do something with the branch databases that are replicating right now, how can I put referential integrity having in mind that only indexes by default has been replicated into existing table structure.
Thanks,
ProBani.
I'm replicating branch databases into HQ, so for all articles I left default options. Then when I checked in subscriber the table structure I saw that referencial intergrity is not reflected (no primary key and foreign keys !!!), only indexes are created. So what I should do is to go in the options for eacch article (table) --> snapshot tab - enable "Include declared referential integrity". Is there possible automatically for all published tables to enable this option, because I have 286 tables!!!
And can I do something with the branch databases that are replicating right now, how can I put referential integrity having in mind that only indexes by default has been replicated into existing table structure.
Thanks,
ProBani.