Create A Copy Of Azure Knowledge Manufacturing unit Utilizing Azure ARM Templates


In day-to-day operations, we will need to have confronted necessities to backup and restore or copy an Azure information manufacturing unit from present to new ones. In as we speak’s demo we’ll see how can we backup and restore the Azure information manufacturing unit utilizing ARM templates export/import possibility in azure information manufacturing unit studio.


I’ll create a easy pipeline that can copy few rows of knowledge from my azure blob storage into an Azure SQL database. For this, I’m going to create a blob storage and add a file into it which we’re going to use to add data into the Azure SQL database. I’ve created a database and with it a desk referred to as monetary which may maintain the info that we’re going to import from blob storage.

You would see from the above image that presently there are not any data within the desk.

The pipeline has accomplished efficiently. Now verify and we will see the database desk and the data which were copied from blob to database desk.

Backup Azure information manufacturing unit

As said earlier, we’re going to make the most of the ARM template Export/Import methodology to backup and restore the Azure Knowledge Manufacturing unit. Go to the ‘Handle’ tab on the left facet pane and choose ‘ARM template’ underneath supply management. The concept is to export the ADF and restore it into a brand new ADF pipeline.

Backup Azure data factory

When you click on Export ARM template you should have a zipper file downloaded into your folder which you must unzip to see the highlighted JSON file is out there. With this step we have now accomplished the backup course of. Now we have now to make use of this file to revive it into a brand new ADF.

Backup Azure data factory

Restore Azure information manufacturing unit

Earlier than beginning with the restore course of we have now to create a brand new information manufacturing unit from azure portal. I’ve named the brand new information manufacturing unit as adfdemo100222. As soon as created open the identical in information manufacturing unit studio and click on on ‘handle’ tab from the left facet pane, adopted by the choices highlighted within the picture under to import ARM template. In the end we’re going to load the ‘arm_template.json’ file from the folder which we have now extracted from the zip beforehand.

Restore Azure data factory

Since we’re loading the ARM template file from the backup we have now created it’s a customized deployment. So as an alternative of selecting the widespread templates, let’s construct our personal template from the editor.

Restore Azure data factory

Within the subsequent display, you will notice the edit template with just a few strains of code, you’ll be able to go forward and delete that and click on on ‘Load file’ possibility above to load the arm_template.json file that we have now extracted from the zip file.

Restore Azure data factory

I’ve modified the title of the file which contained the outdated title to ‘adfdemo100222’ for identification.

Restore Azure data factory

After modifying the title now save the file the place will probably be required to enter the connection string particulars with the useful resource teams and area.

For ‘blob storage connection string’ go to the storage after which entry keys, click on Present keys to repeat the connection string particulars.

  1. Knowledge manufacturing unit title
  2. Connection string of blob storage the place the pattern information has been saved
  3. Connection string of SQL database

Restore Azure data factory

For SQL database connection string particulars go to the databaseà connection string tab within the left facet pane. You may copy the string accessible within the ADO.NET tab and be sure you substitute the password earlier than pasting into the create deployment web page.

Restore Azure data factory

As soon as performed, go forward and ensure it’s efficiently deployed.

Restore Azure data factory

We may see the copy of our restored pipeline from the outdated information manufacturing unit occasion. So you’ll be able to go forward to see how the restored pipeline is working.

Go to the pipeline and simply run the pipeline and verify the rely of the desk data within the database desk. The rely ought to be elevated as the info from the file ought to have been appended within the desk. In my case, the file contained 99 rows and there have been four present rows already taking the rely to 103.

Restore Azure data factory

Restore Azure data factory

We may see that the desk rely has been elevated to 203 rows, 103 present and 99 appended within the second run.

Restore Azure data factory


That is the only type of backup and restore for an azure information manufacturing unit pipeline utilizing ARM template. Hope the reside demo will come useful in case you need to implement such strategies in addition to on your understanding.

Show More

Related Articles

Leave a Reply

Your email address will not be published. Required fields are marked *

Back to top button