Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Assume I've 15 databases, 1 is main database and another is database located at various site. I need to create replication between main database and another. My fellows have tested replication and they conclude that replication can't working correctly if I've set foreign key on some table.

I try to search on google with this kind of problem, unfortunately I've found nothing. I want to make sure, can I create replication between 2 databases with foreign key in some tables or not? If so, please suggest good resource, may be a book to gain some knowledge about its.

share|improve this question
up vote 1 down vote accepted

Yes you can setup replication with foreign keys on the tables. Transactions are on the subscriber in the same order that they are committed on the publisher so if you put data in a parent table, then a child it'll be done in the same order on the subscriber.

share|improve this answer
Do you have any books or links related to this kind of operation? I need to send it to my fellows. =) – Ekkapop Jul 25 '10 at 2:08
Look for "How Transactional Replication Works" in Books OnLine. "Subscribers receive transactions in the same order in which they were applied at the Publisher." – mrdenny Jul 25 '10 at 23:21

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.