replication design for multiple publishers and one subscriber

  • We're on the process of designing our architecture, our solution requires replication from multiple publishers into one subscriber. The problem is, we only have MSDE installed in our publisher's servers but an mssql server 2000 in our central subscriber, so we can't use transactional replication since MSDE doesn't support that model.

    the process is this:

    A request from a user is sent to the central subscriber (cb), the cb then initiates repliction from one of the publishers where his data is located. However, we also need to put user's data into that publishers DB..

    is replication the right solution? if it is? should we use snapshot or merge replication? (however i've read that merge replication with multiple publishers w/ one subscriber is not possible)

    any reply/help would be greatly appreciated

  • Hi,

    Without knowing too much about your case..

    What about using merge replication making the SQL 2000 machine the publisher and all the other MSDEs as subscribers. That way data can be entered at any site and synchronised across all.

    What about Updating Subscribers again using the SQL 2000 machine as the publisher. This would work in a similar way.

    Any good?

    Graeme

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply