up vote 0 down vote favorite
share [g+] share [fb]

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.

link|improve this question
50% accept rate
feedback

1 Answer

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.

link|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
1  
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
feedback

Your Answer

 
or
required, but never shown
discard

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