0

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.

Ekkapop
  • 113
  • 1
  • 4

1 Answers1

1

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.

mrdenny
  • 27,174
  • 4
  • 41
  • 69
  • 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 02: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