sql server replication: Actual Situation -- sql server replication

Actual Situation

Ed
3/14/2005 8:11:03 AM

sql server replication:

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

Re: Actual Situation

Hilary Cotter
3/14/2005 12:39:09 PM

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

[quoted text, click to view]