Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
yakoo
Constraint Violating Yak Guru
312 Posts |
 Posted - 2001-10-10 : 11:08:10
|
| I have a situation where I need to replicate data among three servers. I have tried using merge replication but the data does not merge correctly, most likely due to conflicts.Here is the situation... A product sales application.A primary database, we'll call it SQL1, is used to add/edit/delete products. This database also keeps track of quantity sold (where my problem comes in). Two seperate databases are used by sales teams in seperate offices, call them SQL2 and SQL3, to increment the quantity sold variable. When a product is sold, SQL2 or SQL3 needs to let SQL1 know that we have sold more products which in turn need to let the other server know to increment. So basically the quantity sold variable in SQL1 is a sum of the variables in SQL2 or SQL3.So basically if there is an increment at one server it needs to increment it to all three servers. Does anyone have any insight as to the best way to do this? |
|
|
|
|
|
Replication among 3 servers