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

Ald@13 21 Reputation points
2020-06-02T03:28:47.307+00:00

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

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Warrior 1 Reputation point
    2020-06-02T04:41:31.463+00:00

    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
  2. Mike Ubezzi 2,776 Reputation points
    2020-06-05T01:47:05.283+00:00

    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 tcp:servername.host -P password

    Then load that data file: 

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