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?