If you want to copy huge data from one SQL server to another, try using dbatools which has powershell module underneath.