I have a question where the the two servers are both Publishers and Subscribers.
i.e. Server 'A' publishes and subscribers from Server 'B' - and vice versa.
The goal behind this is to keep data on both servers current - they can ve updated independently of each other but through 'Transactional Replication' the data is kept synchronized without latency.
At least that is what I hope to achieve.
In the above case where the tables can be behaving both as Subscribers and Publisher - do I have to declare the Primary Key as
Identity = 'No'
Identity = 'Yes'
OR Identity = 'Yes (Not For Replication)'
on both servers?
Thanks,
Bianca
i.e. Server 'A' publishes and subscribers from Server 'B' - and vice versa.
The goal behind this is to keep data on both servers current - they can ve updated independently of each other but through 'Transactional Replication' the data is kept synchronized without latency.
At least that is what I hope to achieve.
In the above case where the tables can be behaving both as Subscribers and Publisher - do I have to declare the Primary Key as
Identity = 'No'
Identity = 'Yes'
OR Identity = 'Yes (Not For Replication)'
on both servers?
Thanks,
Bianca