Azure: Copy data from one database to another using Azure Data Factory – II

Ajit Patra

In the previous post, we discussed how to create Azure SQL Server and Azure SQL Database. Now that we are ready with source data/table and destination table, let’s create Azure Data Factory to copy the data.

3. Azure Data Factory:

Click on Create a resource –> Analytics –> Data Factory


Fill the mandatory fields and click Create


After creating data factory, let’s browse it.Click on Author and Monitor.


Click on Author icon on the left –> Click on Connections –> Click on +New under Linked Services tab to create a new linked service.


Select Azure SQL Database — >Click Continue.


Fill the mandatory fields in the next screen. Fill below details on the screen from the previous post:

  • Server Name: Azure SQL Server
  • Database Name: SourceSQLDB
  • Username and Password: SQL Authentication Credential used while setting up Azure SQL server

Click on Test Connection. Once it’s successful…

View original post 682 more words

Author: Nishant Rana

I love working in and sharing everything about Microsoft.NET technology !

Please share your thoughts

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.