January 17, 2003 at 9:53 pm
Is there any special requirements for Transactional Replication? Like no foreign keys or must have primary keys?
When I tried to publish some tables (with Transactional Repl) in my database in create publication wizard, only a few are available to be selected. Others are disabled for publishing, showing an icon with a key and a cross. But when I go back and change the replication to either Snapshot or Merge, all the tables are available to be selected. Why is this?
Thanks,
James
January 18, 2003 at 9:07 am
Primary key is a requirement for transactional. Snapshot is just a bcp copy, so no requirements at all. Merge adds a uniqueidentifier to each table - so even though its not the primarykey its unique and that makes it work. Foreign keys dont matter on the publisher, can cause you headaches on the subscriber.
Andy
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply