Over the next few months, we need to consider the best technology/technique for periodically uploading SQL Server 2008 Express data that is held on a local network up to a Web based SQL Server 2008 server.
The idea is to allow us to consolidate the data in 20 distributed (local) SQL Server Express 2008 apps in use throughout the country into a single database for reporting purposes (SSRS).
The database in each location is using a WinForms/WPF app and I would be looking for the local administrator to click a button in the app once a week/month to upload the latest data to the Web based server.
So, my question is, what technologies/techniques are popular, and what ones should be avoided?