Some thoughts. How does the data get to the SQL Server? What's connecting to it to insert the data? Could that same process be modified to connect to LocationA's server and update remotely via some sort of xml web service?

Or what if the updates being done in the SQL DBs in LocB & LocC were done via Stored Procedures. Then just modify the stored procedure to *also* update the data in the remote server...