I have come accross many situations where a client has data in an accounting system or some other database running on their network. Say they have three locations, each with its own database. They want to consolidate a subset of this data on a single web server so all locations can access info about the entire organization though an ASP or ASP.net web application. I have come accross a few solutions to this. Most are pretty clunky or require each site to have a web server. What are the common ways others handle this common situation? I am thinking as I write this that a vb.net app that runs as a service or is scheduled could periodically extract the data from the local system, connect with the remote database and update the proper tables. Is this a common solution? What are the pitfalls of such a system? What are some of the other ways people handle this? Thanks for the input.