Fastest method to copy 500Gb table from On premise to Azure Sql database

Ald@13 21 Reputation points

I have a requirement to copy 500Gb table from On premise to Azure Sql database having 50DTU.
I tried import and export wizard but getting timeout error along with this msg:
The buffer manager detected that the system was low on virtual memory, but was unable to swap out any buffers. 14 buffers were considered and 14 were locked. Either not enough memory is available to the pipeline because not enough is installed, other processes are using it, or too many buffers are locked.
(SQL Server Import and Export Wizard)

what can be the fastest way for this?

Azure SQL Database
{count} votes

2 answers

Sort by: Most helpful
  1. Warrior 1 Reputation point

    No Import export only works with folders and files. To upload or download that save all files to zip folder then you should be able to export smoothly

    0 comments No comments

  2. Mike Ubezzi 2,776 Reputation points

    Hi Ald13,

    Use the bcp utility, It is super simple and can export on-premise and import to Azure SQL: BCP and SQL Azure

    First, run the utility to export the data:

    bcp db.schema.table out C:\Users\user\Documents\GetDataFromSQLAzure.txt -c -U username@servername -S -P password

    Then load that data file:

    bcp db.schema.table in C:\Users\user\Documents\MoveDataToSQLAzure.txt -c -U username@servername -S -P password