none
Azure SQL Server table data Archive Automation RRS feed

  • Question

  • How can I automate my archival plan in Azure SQL Database?

    I have one log table; I want to move older (30 days) data to move my log archive table.

    Wednesday, June 15, 2016 1:47 PM

Answers

  • You can use Azure Scheduler or webjobs to create background tasks that run in certain time interfaces (see https://azure.microsoft.com/en-us/documentation/articles/web-sites-create-web-jobs/). I think webjobs are the simplest for you. You can create a script that moves the data that is older that X, from A to B. In your case a .NEt Console App or a PowerShell script would be easy to build.

    The webjob can be scheduled to run once every day and such automate the move action of your database

    Hope this helps

    Sander

    Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question. Even if you are not the author of a thread you can always help others by voting as Helpful. This can be beneficial to other community members reading the thread.

    Wednesday, June 15, 2016 2:29 PM