CODEWITHSUNDEEP
sqlazure
tatung
tatung

Reputation: 23

Periodically update data in Sql Azure Database

I have an SQL Azure Database instance which provide data to a windows 8 app. The data in my database should be updated periodically (weekly). Is the any way to make it? I'm thinking of write a app which will run weekly and update the database. But still don't know how to make it run on Window Azure? Please help! Thank you,

Upvotes: 0

Views: 412

Answers (2)

cillierscharl
cillierscharl

Reputation: 7117

There are a number of ways to achieve this, does the data however need to come from a different source or can it be calculated?

Either way, seeing as you're already knee deep in SQL Azure I would suggest putting your logic into a worker role that can be scheduled to run your updates once a week. This would give you a great opportunity to do calculations and/or fetch data externally.

Azure gives you the flexibility to scale this worker role into numerous instances as well depending on the work load.

Here is a nice intro tutorial on creating a worker role on Azure: link

Upvotes: 1

Gosundi
Gosundi

Reputation: 45

Write the application and set it to run through your cron job manager on a weekly time schedule. The cron job manager should be provided by your host.

Upvotes: 0

Related Questions