Actual Situation

Hi,
I am at the head office of the company and we have 9 locations nationwide.
We don't generate any transaction in the database in the head office. We
only collect data from other location.
I am asked to transfer the Inventory system about the partnumber and
quantity on hand to the head office every hour.
Which replication should i use, Snapshot, Merge, or Transactional?
Thanks for any suggestion
Ed
Probably transactional - what you are trying to do is called a central
subscriber.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Ed" <Ed@.discussions.microsoft.com> wrote in message
news:AE5E3B36-1D43-4BA5-984D-7C02745FFA72@.microsoft.com...
> Hi,
> I am at the head office of the company and we have 9 locations
nationwide.
> We don't generate any transaction in the database in the head office. We
> only collect data from other location.
> I am asked to transfer the Inventory system about the partnumber and
> quantity on hand to the head office every hour.
> Which replication should i use, Snapshot, Merge, or Transactional?
> Thanks for any suggestion
> Ed