Taking too much time to upload data to Azure SQL Database using linked server RRS feed

  • Question

  • We have set up a linked server at our database and try to upload 100000 records from one of the tables of our database to Azure database.It took around 2 hours to complete the transaction. 
    We tried to download the same number of records from Azure to our database using the same linked server at our database and it took only 3 minutes.

    What is the reason for the huge difference in time ?

    Tuesday, August 23, 2016 3:12 PM