sql server replication: Type of Replicatoion ? -- sql server replication

Type of Replicatoion ?

Shahid Saleem
3/28/2005 9:05:03 PM

sql server replication:

Dear All

We have developed an Order processing Application, We have Head Office and
three branch offices located throught the country, Each brach office has its
own SQL server installed , at the end of day we want to gather all branch
offices data into our head office sql server , I have planned to use Merge
replication and branch office computers as publishers and Head office as
subscriber. I need your expert opinion wether this type of replication is
best or the goal can be achieved by using some other techniques ,

--
Best Regards

RE: Type of Replicatoion ?

Shahid Saleem
3/29/2005 1:45:12 AM

Paul

Thanks for your comments, But how can I make HO as publishe cause new orders
are being entered at branch offices and i need to retrive these new entered
orders into HO DB

[quoted text, click to view]

RE: Type of Replicatoion ?

Paul Ibison
3/29/2005 2:36:48 AM

In merge the publisher/subscriber metaphore doesn't
really hold, at least not in the same way as
transactional. Both the publisher and subscriber can
enter data ie it is inherantly bidirectional by default.
HTH,
Paul Ibison SQL Server MVP,
www.replicationanswers.com/default.asp
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

Re: Type of Replicatoion ?

WB
3/30/2005 10:06:13 AM

I would also recommend the HO be the publisher and the branch offices be
subscribers. In addition, through the merge agent you can setup an update
that is more frequent than "End of Day" which would give your HO and branch
offices more of a "real time" picture of your data.

WB

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server replication group.