Timeline for Replication of database used by two programs
Current License: CC BY-SA 3.0
8 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jan 6, 2012 at 20:27 | history | tweeted | twitter.com/#!/StackDBAs/status/155384975208873984 | ||
| Jan 4, 2012 at 17:35 | answer | added | Brandon Williams | timeline score: 2 | |
| Jan 4, 2012 at 15:25 | comment | added | gbn | @Stewie: Is UserID your PK or do you have an IDENTITY (to clarify MartinC's quesation). Also add table definition to be sure | |
| Jan 4, 2012 at 15:21 | history | edited | gbn | CC BY-SA 3.0 |
added 2 characters in body
|
| Jan 4, 2012 at 13:59 | history | edited | MartinC |
edited tags
|
|
| Jan 4, 2012 at 13:56 | comment | added | MartinC | Have you setup the IDENTITY ranges for your tables so that they don't overlap between the servers? Peer to Peer needs to be configured so that as much as possible conflicts are avoided. | |
| Jan 4, 2012 at 11:02 | comment | added | Andrew Bickerton | How have you setup the replication? if you want to be able to write to both servers you would need it to be merge replication, if it's transactional replication, one server will be denoted as the 'publisher' and you will get errors when the publisher tries to send an insert of a new row to the subscriber where the ID has already been used... | |
| Jan 4, 2012 at 9:37 | history | asked | Stewie | CC BY-SA 3.0 |