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



6 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
  3. THIS IS THE BEST THING THAT HAS EVER HAPPENED TO ME
    I was scammed of $379,000 worth of bitcoin with a scam forest investment unknowingly then,
    I didn’t know what to do.. I felt like committing suicide, but fortunately for me, my friend introduced me to a cyber crime investigator ( Mr Morris Gray )who also helps in recovering lost invested funds, After working with him, to my greatest surprise, in just few days I got all my lost funds back, and he only took just 15% out of the recovered funds, if you have been scammed with fake forex you don’t need to be scared or worried, because you can also reach him on his email: MorrisGray830@ gmail .com
    He will recover your lost bitcoins back fast and smoothly...
    You can WhatsApp him via +1 (607) 698-0239.
    And you will be amazed….!!!

    ReplyDelete
  4. HELLO EVERYONE,

    Welcome to the future! Financing made easy with Prof. Mrs. DOROTHY LOAN INVESTMENTS

    Have you been looking for financing options for your new business plans, Are you seeking for a loan to expand your existing business, Do you find yourself in a bit of trouble with unpaid bills and you don’t know which way to go or where to turn to? Have you been turned down by your banks? MRS. BEATE HEISTER LOAN INVESTMENTS says YES when your banks say NO. Contact us as we offer financial services at a low and affordable interest rate of 2% for long and short term loans. Interested applicants should contact us for further loan acquisition procedures via msbeateheister@gmail.com Whatsapp; +1 (540) 209-1989

    Services rendered include:

    *Refinancing Loans
    * Car Loan
    *Truck Loans
    * Home Loan
    * Mortgage Loan
    * Debt Consolidation Loan
    * Business Loan [secure and unsecured]
    * Personal Loan [secure and unsecured]
    * Students Loan and so many others.

    For more info; Contact us via Email: msbeateheister@gmail.com or Whatsapp; +1 (540) 209-1989 With Prof. Mrs. BEATE HEISTER LOAN INVESTMENTS. you can say goodbye to all your financial crisis and difficulties as we are certified, trustworthy, reliable, efficient, fast and dynamic

    ReplyDelete
  5. Buy Legit Passports, Id Cards, Drivers License And Much More (obtain Full Nationality For Any Country), Passports, ID cards, Drivers license, Working permits, Birth/Marriage certificates(Whatsapp:+19254121971)(puredocuments21@gmail.com)

    Buy Legit Passports,Id Cards,Drivers License And Much More(Whatsapp:+19254121971)(puredocuments21@gmail.com)

    Buy Legit Passports,Id Cards,Drivers License And Much More(obtain Full Nationality For Any Country)(Whatsapp:+19254121971)(puredocuments21@gmail.com)

    BUY REGISTERED PASSPORTS,DRIVERS LICENSE ONLINE(Whatsapp:+19254121971)(puredocuments21@gmail.com)

    BUY ORIGINAL PASSPORTS,VISAS,CITIZENSHIP DOCUMENTS FOR YOUR DREAM COUNTRY(Whatsapp:+19254121971)(puredocuments21@gmail.com)

    New Citizenship!!USA/UK/Canada/Australia/EU;Passports,Visa,ID cards,Drivers License,USA Greencard(Whatsapp:+19254121971)(puredocuments21@gmail.com)

    Buy Real and Fake Passports,Drivers license, Citizenship Documents Online(Whatsapp:+19254121971)(puredocuments21@gmail.com)

    Buy Real and Fake Passports,Visas,Drivers License Online(Whatsapp:+19254121971)(puredocuments21@gmail.com)

    Buy Real and Fake Drivers License Online(Whatsapp:+19254121971)(puredocuments21@gmail.com)

    Buy Registered Passports,Drivers License Online(Whatsapp:+19254121971)

    Buy Fake Passports Online(Whatsapp:+19254121971)(puredocuments21@gmail.com)

    Buy Fake Drivers License Online(Whatsapp:+19254121971)(puredocuments21@gmail.com)

    Buy Legit Passports Online(Whatsapp:+19254121971)(puredocuments21@gmail.com)

    Buy Legit Drivers License Online(Whatsapp:+19254121971)(puredocuments21@gmail.com)

    Buy Registered EU/USA/UK/Canadian Passports,Driver’s License,ID Cards,Visas, USA Green Card,Citizenship(Whatsapp:+19254121971)(puredocuments21@gmail.com)

    get passport online(Whatsapp:+19254121971)(puredocuments21@gmail.com)

    citizenship application online(Whatsapp:+19254121971)(puredocuments21@gmail.com)

    get my passport online(Whatsapp:+19254121971)(puredocuments21@gmail.com)

    buy real passport online(Whatsapp:+19254121971)(puredocuments21@gmail.com)

    immigration and naturalization service(Whatsapp:+19254121971)(puredocuments21@gmail.com)

    buy registered passports online(Whatsapp:+19254121971)(puredocuments21@gmail.com)

    Registered passports online(Whatsapp:+19254121971)(puredocuments21@gmail.com)

    Citizenship online(Whatsapp:+19254121971)(puredocuments21@gmail.com)

    Online driver's license(Whatsapp:+19254121971)(puredocuments21@gmail.com)

    buy registration id card online(Whatsapp:+19254121971)(puredocuments21@gmail.com)

    buy real id cards online(Whatsapp:+19254121971)(puredocuments21@gmail.com)

    buy birth certificate online cheap(Whatsapp:+19254121971)(puredocuments21@gmail.com)

    buy social security card online(Whatsapp:+19254121971)(puredocuments21@gmail.com)

    buy copy marriage certificate uk(Whatsapp:+19254121971)(puredocuments21@gmail.com)

    buy emancipation certificate online(Whatsapp:+19254121971)(puredocuments21@gmail.com)

    Buy SSN Online(Whatsapp:+19254121971)(puredocuments21@gmail.com)

    Buy high quality Passports USA(Whatsapp:+19254121971)(puredocuments21@gmail.com)

    Buy UK Drivers License(Whatsapp:+19254121971)(puredocuments21@gmail.com)

    Buy UK registered passport(Whatsapp:+19254121971)(puredocuments21@gmail.com)

    buy genuine passport online(Whatsapp:+19254121971)(puredocuments21@gmail.com)

    buy genuine passport online(Whatsapp:+19254121971)(puredocuments21@gmail.com)

    buy real registered passport online(Whatsapp:+19254121971)(puredocuments21@gmail.com)

    buy ssn card online(Whatsapp:+19254121971)(puredocuments21@gmail.com)

    buy real driver's license online(Whatsapp:+19254121971)(puredocuments21@gmail.com)

    buy real registered drivers license(Whatsapp:+19254121971)(puredocuments21@gmail.com)

    buy real and fake drivers license online(Whatsapp:+19254121971)(puredocuments21@gmail.com)

    apply for citizenship online(Whatsapp:+19254121971)(puredocuments21@gmail.com)


    ReplyDelete
  6. hack into email accounts and trace email location -all social media accounts, -school database to clear or change grades, -Retrieval of lost file/documents -DUIs -company records and systems, -Bank accounts,Paypal accounts -Credit cards hacker -Credit score hack -Monitor any phone and email address -Websites hacking, pentesting. -IP addresses and people tracking. -Hacking courses and classes CONTACT THEM= Brillianthackers800@gmail.com, Whatsapp No: +14106350697 their services are the best on the market and 100% security and discreet work is guaranteed.

    ReplyDelete