I can't seem to find the answer to this in the documentation.
I have several tables that I want to replicate via transactional replication. These tables do have some foreign keys between them.
What are the advantages/disadvantages of "one table per publication" versus "one publication with all of these tables listed as articles"?
If I do not define these in the same publication, will I get into trouble with the order that data is loaded to satisfy the foreign key constraints?
THe big disadvantage is management overhead of multiple publications. But for your scenario, you can mark FKs as not for replication at the subscriber if you want. However with tran, it will maintain and replicate in the exact order it was applied at the publisher.
No comments:
Post a Comment