Kind of Replication will work ?

HI
We have 1 Central office Corporate Office and three branch offices. We
are in process of developing an Order Management Application, Every
branch will enter Inquiries/Quotation/Orders into application and at the
end of day we want all data entered at every branch to be available at
corporate office for further processing, can you please advise me kind
of replication will work for us. Thanks in advance
Best Regards
Shahid Saleem
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!
It looks like you only want data flowing one way, from the branch offices to
the central office. In this case I would use transactional replication.
The next question you have to ask your self is, is there anything unique
about your data in the branch office which makes it identifiable as
belonging to that branch? If so, you should filter on this data, and when
you are in the specify articles dialog for the publication, click on the
browse button to the right of your table name, select the snapshot tab, and
select the delete all data in the existing table that matches the row filter
statement.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"Shahid Saleem" <shahid_mcsd@.hotmail.com> wrote in message
news:e3l4fOx8EHA.2568@.TK2MSFTNGP10.phx.gbl...
> HI
> We have 1 Central office "Corporate Office" and three branch offices. We
> are in process of developing an Order Management Application, Every
> branch will enter Inquiries/Quotation/Orders into application and at the
> end of day we want all data entered at every branch to be available at
> corporate office for further processing, can you please advise me kind
> of replication will work for us. Thanks in advance
> Best Regards
> Shahid Saleem
> *** Sent via Developersdex http://www.codecomments.com ***
> Don't just participate in USENET...get rewarded for it!