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 |
|
ozgunnew
Starting Member
13 Posts |
 Posted - 2006-09-19 : 07:01:59
|
| Hi;I want to construct a MERGE replication by central subscriptor and multiple publishers model.Is this possible?Does anyone have idea about what kind of problems this model causes during initial syncronization and in later steps?If a table gets data from multiple publishers (i guarantee that no conflict can orrur, because all databases deal with different data), will there be any problem?Thank you so much. |
|
|
Rishi Maini SQL2K5 Admin
Yak Posting Veteran
80 Posts |
Posted - 2006-09-19 : 14:52:31
|
| I think you need to be more descriptive about the business logic that you need to implement. I think Merge can handle majority of the scenarios including conflicts and filters that you can apply. I am not sure why do u want this kind of setup ? What if you mark the Subscriber for re-initialization for a simgle Publication. It will drop the table and recreate it again affecting other Publications.ThanksRishi Maini |
 |
|
|
ozgunnew
Starting Member
13 Posts |
Posted - 2006-09-20 : 02:40:49
|
| Hi;We have one center in one city and several branches in other cities.MSDE will run in branches and sql server 2000 will run in center.Users in center want to see all the data entered in branches.But other direction is not required. (Users in center also enter data) Because of the fact that msde can be transactional publisher i think the only solution i can use is merge replication.One option is to make center publisher - branches subscribers and enable one way replication from subscriber to publisher.Other option is to make each branch publisher-center subscriber and enable one way replication from publisher to subscriber.I am trying to decide which option is better.Because of the fact that center and each branch have different set of data, i think i should never use re-initialization.Can you propose any solution about this structure?Thank yo so much. |
|
|
|
Rishi Maini SQL2K5 Admin
Yak Posting Veteran
80 Posts |
Posted - 2006-09-21 : 03:48:07
|
| I would go for the first one i.e. (One option is to make center publisher - branches subscribers and enable one way replication from subscriber to publisher)ThanksRishi Maini |
|
|
|
|
|
|
merge rep. with central subscriber.