Importing data into DB on shared hosting every evening

grahamor · 21-05-2008 09:59PM #1

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 · 21-05-2008 10:39PM

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 · 21-05-2008 11:22PM

Could you schedule this from within SQL Server itself?

Ginger · 22-05-2008 06:53AM

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 · 22-05-2008 09:39AM

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

Importing data into DB on shared hosting every evening

Comments