How to Create & Load Tables in Azure SQL Database from On-Prem SQL Server Database

 Issue: How to Create & Load Tables in Azure SQL Database from On-Prem SQL Server Database.


In this article, we are going to learn, how to crate and load tables in Azure SQL database from on-prem SQL server database, lets start our demonstration.

How to connect On-Prem Azure SQL database with Azure SQL database:

Open your SQL Server Management Studio and connect with the Azure SQL database, Provide the server name, then select the authentication type, then provide your user name & password and then click on connect.


Once we are connected with the Azure SQL database, go to the Azure Data factory studio, then go to the author and then click on + sign to create a new pipeline, then find and drag the lookup activity, then click on settings and then click on + New to create a new source dataset, from where we will read the list of tables which we have to copy to our Azure SQL database.


Find and select the SQL server and then click on continue.


Name the dataset, then select the linked service, select none for import schema and then click on ok


Next, in the settings tab click on the query, and write the query to obtain list of the tables.


Next, find and drag the ForEach loop activity, then connect with the Lookup activity, then go to the settings tab and click on ''Add dynamic content''.



Now, go inside the ForEach loop activity by clicking on a Pencil sign on the ForEach loop activity then find and drag the copy data activity, then go to the source tab and then click on + New button to create a new source dataset.


Find and select the SQL server and then click on continue.


Name the dataset, then select the linked service, select none for import schema, and then click on ok.










Next, in the source tab click on the Open button to create a parameter as we dont select the table name because ww have to rad the all tables from our on-prem, in that case we have to create a parameter and that parameter we will use in our connection. go to the parameter tab then click on + New, then create a parameter.


Then in the connection tab, provide the schema name then select the parameter which we have created and then go to the pipline.

Now go to the sink tab, and click on + New button to create a new sink dataset.


 
Select Azure SQL database and then click on continue.


Name the dataset, then select the linked service, select none for import schema, then click ok.


Now, create a parameter and provide the values for the sink datset set where we will write our files and then debug the pipeline.





Video Demo: How to Create & Load Tables in Azure SQL Database from On-Prem SQL Server Database



1 comment:

  1. BINARY SCAM RECOVERY

    ❌ Binary Option, Forex and their likes are a means of making money but it’s more like gambling. There are no sure means to guarantee that a person could make profit with them and that’s why it can also be reasoned to be scam. Let’s not forget that some individuals even give you 💯 % guarantee of making profits and end up running away with your money. The internet today is full of Binary Option Recovery Scam, you see so much testimonies been shared about how a firm or Company helped them recover what they lost to Binary Options. But believe it, it’s just a way to lure more people and end up scamming them.

    ❌ You might have also come across some individuals that say they will give you guarantee on successful trades but they only end up as SCAMMERS as well. You here them say stuffs like 200% guaranteed in just 2 weeks and when you go into trade with them, they start telling you to pay profits percentage before you can get your income. These are all liars please avoid them. But if you have been a victim of this guys, then you should contact FIRMWARE now‼️

    ✳️The big Question is “Can someone Recover their money lost to Binary Option and Scam⁉️
    I will say yes, and will tell you how.

    The only way to Recovery your money back is by hiring HACKERS to help you break into the Firms Database Security System using the information you provide them with, Extract your file and get back your money. It seems like a really impossible thing to do, I will tell you, it should be impossible, but with the use of specially designed softwares known to HACKERS and Authorities (such as The FBI, CIA e.t.c) it is possible and the only way to recover your money.

    ✅FIRMWARE are a group of hackers who use their hacking skill to hunt down SCAMMERS and help individuals recovery their money from Internet SCAMMERS.
    We just need the contact details of the SCAMMERS and Paymnet Info and within 4-8 hours your money will be return to you.

    ✳️ You can contact us via the emails below-:
    firmwarehacks@gmail.com


    We also provide Legit Hacking Services such as-:
    🔸Phone Hacking/Cloning
    🔸Email Hacking & Password Recovery
    🔸Social Media Hacking & Passowrd Recovery
    🔸Deleted Files Recovery 🔸Mobil Tracking
    🔸Virus detection & Elimination.

    Email-: firmwarehacks@gmail.com




    Firmware
    2022 © All Right Reserved.

    ReplyDelete