Hi,

I am new to the advanced concepts of SQL server 2005. We have a web
application that will be installed at multiple sites across the US.
The databases at each of these sites will be updated, populated, by
the applications running at the respective sites. The schema of the DB
at each site is the same.The tables will have ID columns set at
IDENTITY columns so that IDs are generated on their own.

We would like to synchronize some tables in the DBs among the
different sites. Is SQL Server replication the right choice for this?
All the sites will have to act as a Publisher as well as a Subscriber.
The replication as I understand would have to happen as:
Site1--->Site2--->Site3--->Site4. Site4 would have the cumulative data
of Site1-4. The reverse synchronzation would be:
Site1<---Site2<---Site3<---Site4. All sites would thus have the data
from synced.

Is this the right approach? Does SQL Server provide the facility to
set up a chain of Publishers and Subscribers as described above?
Is there a particular Type or configuration we should be using?

Any tips, suggestions would be helpful.

Thanks,
Yash