A question for discussion regarding replicating and SqlServer databases.
As I understand it, SQLServer has an automatic way to handle replicating with another database, and I am going to assume that it works without a hitch.
My problem with replicating stems from the fact that we want to replicate our database which includes a table that has unique ids, our Objects table. That is to say we have a identity on Objects.ObjectId and we use this all over the place.
When reading documentation on replicating, no one seems to go into any detail about what would happen if on machine A and machine B different records get created, both with the same Identity, Objects.ObjectId in my case.
Would there now be 2 records with a given ObjectId in the database? If it does automatically change it, how would I know about it so I could adjust the other objects that reference that?