sql server replication: Hi,
I would like to make the concept clear that if i have two individual
servers let's say one in CA and one in TX. i want them to be able to syn.
data (look at each other inventory data), I should use Merge Replication.
If I want to sent CA and TX data to headquater in NY, I should use
transactional Replication, am I right?
Thanks again

Ed,
bidirectional transactional replication could also be
used between CA and TX. I'd consider this if the data is
partitioned and there is no posibility of conflicts, you
can manage both sites and the schema won't change. In
these cases it is worth looking at, as it is tremendously
faster than merge.
For CA and TX to NY, I'd use transactional - multiple
publishers and one subscriber. Merge can give easier
management with NY as a publisher, but if you have
connectivity to CA and TX and know what you're doing
administrationwise, then definitely transactional.
HTH,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)