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



11 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
  7. Have you heard about Cryptocurrency, bitcoin, Ethereum or Dogecoin? It's the trending form of investment that can change your financial status for the better. This was how I got to meet with the wrong platform for crypto investment and was duped over $100,000 USDT. This was supposed to be an investment plan that will change my life and sustain me for years ahead. I was ripped off and didn't know where or how to go about it. While surfing through the internet, I came across a pop up talking about Spyware Cyber and how they help victims recover stolen funds. This was quite scary to me but I chose to see how it would turn out. After few days of investigation , I got back my lost funds in full. I am so happy as I have decided to let the world also know about their effective service. Their contact information is as follows: spyware(@)cybergal(.)com

    ReplyDelete
  8. Have you ever been a victim of a romance scam? Have you been defrauded of your hard-earned money by these online scammers pretending to be investors on Instagram? If you have lost your cryptocurrency or sent cryptocurrency to these online scammers before then you have absolutely nothing to worry about as wardrivers are here to help you recover whatever you must have lost to these online scammers. I was in the same situation as you until I came across an article about Wardriver's cyber service and how they can help me recover my lost funds, I didn't believe them at first but after giving it a try, I was able to recover my $807,000.00 that I lost to cryptocurrency investment scam in 48 hours. This recovery company is known for how effective its services are. They carefully analyze the information sent to them and track down these scammers, Wardrivers ensures your funds are returned to you without leaving a penny behind and the scammers are handed over to the authorities for further investigation. Don't hesitate to contact Wardriver's cyber-service at EMAIL: ( wardriverscyberservice(@)techie(.)com) WhatsApp: +1 ( 6 1 6) 8 9 8-7 2 8 5

    ReplyDelete
  9. I got conned recently by a cryptocurrency trader to who I got connected online. It got me depressed for weeks until a friend of mine told me about Cyberwallfire, a team of professional hackers who helped him to recover his stolen bitcoins two years ago. I contacted them immediately and provided all the information they asked for, and within 48 hours, all the money that I lost in bitcoins investing in a fake cryptocurrency platform was recovered completely. I’m super excited and decided to share this information with everyone. Cyberwallfire was very helpful and quick in recovering my funds, they are very efficient and trustworthy. I urge everyone who has previously been conned online to reach out to them to recover their money. Reach them directly at cyberwallfire(@)techie.com

    ReplyDelete
  10. Best Hacker Contact RecoveryMasters

    I was in need of a very good hacker then i was referred to these wonderful hackers named RecoveryMasters who helped me hack into my spouse phone without my spouse knowing such a hack was done on his phone RecoveryMasters hacked into my spouse whats-app messages, call logs, text messages, deleted text messages, Viber, emails and many more i got result under 24 hours and I found out my spouse has been a big time cheat thanks to these great hackers you all can also contact them via email ( Recoverymasters@email.cz ) or whatsapp +1(551) 202-23-35 if you have any form of problem. They are solution makers. Tell them Hina referred you to them and I am sure they will help you with your proof.

    ReplyDelete
  11. I lost $780,000 worth of Bitcoin to a fake online coin investment company called Coin Flip Trade and I was about to lose my mind, but digital triangulation expert Kravitz Hein of (claimpayback on google) went out of his way to help me recover every single coin stolen from me after I had provided the adresses and transaction hashes generated by providing me with links and steps when I was about to lose my mind.
    They went on to explain that these guys have a leverage wallet linked to their phony investment platform, which they use for trading.
    Thank you very much.
    You can contact him about any recovery issue.
    I recently detached 65btc from the the outsourced wallets. im waiting for the Erc20 gas fee to be able to detach the rest

    ReplyDelete