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.