1

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.

Taras Kovalenko
  • 2,323
  • 3
  • 24
  • 49

1 Answers1

1

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.

Community
  • 1
  • 1
elfisher
  • 1,210
  • 9
  • 14