foreign key constraint

i have a publication that is composed of

many articles. The publication is composed of many

realated tables. I'm doing a snapshot replication

Is there a way to specify the order by which table

must synchonize.

lets say. article 1 synchonizes first, then article 3, then article 2




Answer this question

foreign key constraint

  • Docseuss

    are you getting foreign-key constraint errors, is that why you ask if so, you can mark the foreign keys as "Not For Replication", this way they're not enforced when replication runs. You can also choose not to script foreign keys at the subscriber, if you wish.
  • foreign key constraint