>We are developing an application for some remote locations to process orders; however, these remote locations need to have updated customer, products, and pricing information. Generally, this information will not change frequently, so real-time access is not necessary. However, we will need to update it daily and I'm just wondering what would be the best way to transmit the up-to-date information to them.
>
>We thought of creating the new files on a nightly basis and then putting them somewhere where the remotes could download the updated files, but now I'm thinking that perhaps it might be better to let the remote offices initiate the "update". This might be by creating a web service that would transfer the data to them.
>
>Any suggestions for me?
If you only need to pull data you might consider to create a linked server on an sql server. We use it all the time and it works very well ...