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



2 comments:

  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
  2. Have you lost your hard earned money to:1.Binary option scam??
 2. Forex trading?
 3.Romance scam
?? 4. Expertoption scam?? and any other kind of online investment? 
I have a good news for you. Contact Recoverbtchelp07 
 I had doubts it was possible to recover the funds I lost to binary options. However, big thanks to Recoverbtchelp07 now for helping me recover a huge sum back and still working on full recovery for me.
 They are nothing but the best. You should contact them now!! and have a taste of quick funds retrieval with no upfront payment and tricks... Don’t be deceived by the fake assess. Nothing can be compared to peace of mind and excellent service. The real deal is Recoverbtchelp07 at gmail dot com for an outstanding and honest service.......... Whatsapp or text: +1 315 784 1311

    ReplyDelete