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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-01-07 : 08:04:13
|
| Chen writes "hello.I have two question concerning two way replication on SQL server 2000 (with SP2).1. I have built two way transactional replication with updated subscriber. It works fine when applying update clauses. But when I try to insert new record on the subscriber I come a cross a problem- identity fields: simultaneous inserts on both publisher and subscriber causes manufacturing same identity to different records- one on publisher, one on subscriber. the Ranges property of the replication did not help this problem. After pushing the ranges two times correctly the problem arose again.How can I solve this? Should I work with merge replication or is updating-subscriber enough for me?2. Is it possible for one database to be both publisher and updating subscriber? I need it to be updating subscriber to server A and publisher to server B. B<---X<--->Athank you very muchChen" |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-01-07 : 12:36:19
|
| Merge replication is what you want.Tara |
 |
|
|
|
|
|
two way replication on SQL2000