actually their is a scenario in which 1 central db as publisher and 4 subscriber database we are trying for transactional replication but as we all know that table with primary key can only be replicate .so how can we replicate non defined primary key table please tell me the solution .or we should go for any other replication terminology .their is no other method to make it possible in transactional replication....
For transactional replication, you need primary key. Without that you cannot do it. You can use Snapshot replication if the data in the table that has no primary key does not change much. And the table is not very large.
-Roy
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply