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

aa

Fill the mandatory fields and click Create

a1

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

aaaa

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

bb

Select Azure SQL Database — >Click Continue.

cc

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

Advertisements

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:

WordPress.com Logo

You are commenting using your WordPress.com 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.