Here's a little situation which may have several different solutions, but I would like to hear (read) the solutions that you put forward.

We have offices in LocationA, LocationB, LocationC.

The SQL Server at LocationB will contain information about the office at LocationB.

The SQL Server at LocationC will contain information about the office at LocationC.

Now, LocationA, this is a little different. It needs to contain information about LocationA, and in addition, all information about LocationB and LocationC.

Any changes that occur in the database tables at LocationB and LocationC are required to be sent to LocationA as well. If not immediately, then say, within a few seconds or a maximum of say... 1 minute.

The first thing that came to my head was SQL Server Transactional Replication. But from the description I read,

Transactional replication offers a more flexible solution for databases that change on a regular basis. With transactional replication, the replication agent monitors the publisher for changes to the database and transmits those changes to the subscribers. This transmission can take place immediately or on a periodic basis.
It seems to be rather IO intensive.

Any other suggestions to achieve this? Or if you agree with Transactional Replication, then why? Whatever you think, I'd like to read it.