Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2008 Forums  Other SQL Server 2008 Topics  webservice to allow remote access to data

Author  Topic  cr0wn3r Starting Member 1 Post Posted - 2010-02-19 : 20:36:32 I am working on a project at the moment that will use data from a remote mission critical sql 2008 database to drive a web app on another server at another location. The app does not need to write to the db - only read. Because of this, my first thought was to use a web service to allow the sql db to serve specific data over the web, probably then stored locally by the app once a day using a cron job. This would keep the web app from hitting the sql server with too much traffic as it would be acceptable for the data displayed by the web app to be updated every 24 hours. I anticipate a lot of learning ahead in setting up the web service as my sql2008 usage has never gone beyond select statements... but does the above sound feesable, and does anyone have any tips or links to resources that would be helpful? The web app that will be displaying the data is a php / mysql portal, specially built already to present the data. I just need a reliable safe way of regularly getting the relevent data from the sql2008 server in to the web apps mysql db.