Periodically update data in Sql Azure Database

Question

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,

cillierscharl · Accepted Answer · 2012-11-09 17:30:04Z

1

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

answered Nov 9, 2012 at 17:30

cillierscharl

7,1053 gold badges31 silver badges46 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

tatung Over a year ago

Thank you very much for your suggestion. I understand now and following your link.

Gosundi · Accepted Answer · 2012-11-09 17:16:17Z

0

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.

answered Nov 9, 2012 at 17:16

Gosundi

454 bronze badges

Collectives™ on Stack Overflow

Periodically update data in Sql Azure Database

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related