If you want to copy huge data from one SQL server to another, try using dbatools which has powershell module underneath.
In the demo here, I’ve compared 2 dbatools commands to move data from one SQL server to another:
Write-DbaDbTableData vs Copy-DbaDbTableData
Click through to see which one wins the speed challenge.