CODEWITHSUNDEEP
azure-sql-database
Taras Kovalenko
Taras Kovalenko

Reputation: 2393

Azure Sql Cron - how to use?

I have some db with data. And I need create script for migrate data from tableA to tableB. I use C# and azure web sites web-job. But I think what exists Cron for azure sql. But I can't found this. Maybe you know how to use Cron in Azure SQL. Because I can't found it. Thanks.

Upvotes: 1

Views: 509

Answers (1)

elfisher
elfisher

Reputation: 1230

There are many ways to migrate data from one table to another in Azure SQL Database. One way is to use TSQL. If this is a routine task, you may want to look into creating a stored procedure and leveraging Azure Automation to run the stored procedure on a schedule.

This forum answer shows how to use TSQL to copy from one table to another.

There is a blog post which shows how to use Azure Automation with Azure SQL Database here.

Upvotes: 1

Related Questions