Importing data into DB on shared hosting every evening

grahamor

Hi,

For a future project, i need to call a webservice at midnight, every night to import up to date data into a MS SQL DB.

The DB is on a shared hosting box, so im wondering what options i would have to call the code automatically that would call the web service that would import the data into the db.

edit, im using C# and ASP.NET

Thanks alot.

forbairt

windows task scheduler ?

I'm not sure of the kinda of access you're allowed on the system though ...

I know I set this up on XP before .. (but it was a local machine) on linux I'd just say use cron ....

Evil Phil

Could you schedule this from within SQL Server itself?

Ginger

SQL 2005 supports CLR functions which you could have set to run using the SQL Agent as a job..

This post does a walkthrough of creating a CLR function to call an external web service.

You can then schedule the SP to run at midnight every day

stevenmu

You could also just write an app that will run on a local PC/server that calls the webservice, gets the data and writes it to your remote SQL server. And schedule it with the windows scheduler mentioned above