gps.docker/daldb/bcpScripts/copyData.ps1

$tables = @("ProductType","CurrencyMaster", "Cards", "Transaction", "Transaction_Int", "Payment_Token")
for ($i=0; $i -lt $tables.length; $i++) {
    $table = $tables[$i]
    $fmtOut = "AlexisManualQA.dbo.[${table}] format nul -f ${table}.fmt -n -S PTSMAIN -U gpspl -P yW2S6KXdY8"
    $bcpOut = "AlexisManualQA.dbo.[${table}] out ${table}.bcp -n -S PTSMAIN -U gpspl -P yW2S6KXdY8"
    Start-Process bcp -ArgumentList $fmtOut -Wait
    Start-Process bcp -ArgumentList $bcpOut -Wait
}