gps.docker/clearingdb/bcpScripts/copyData.ps1

New-Item -ItemType Directory -Force -Path bcp/AlexisPTSTest
$tables = @("dbo.CurrencyMaster", "dbo.CountryMaster", "dbo.Cards", "dbo.Configuration", "dbo.Cards_FX_Group", "dbo.Groups_FX_Master", "dbo.Groups_Fx_Details", "dbo.ProductType", "dbo.Bank", "dbo.VISA_CIB", "dbo.Response_source", "dbo.Payment_Token_Type", "dbo.Users", "dbo.Wallet_Provider", "dbo.Payment_Token", "ForeignExchange.ProductCCY")
for ($i=0; $i -lt $tables.length; $i++) {
    $table = $tables[$i]
    $fmtOut = "AlexisPTSTest.${table} format nul -f bcp/AlexisPTSTest/${table}.fmt -n -S localhost -U gpspl -P yW2S6KXdY8"
    $bcpOut = "AlexisPTSTest.${table} out bcp/AlexisPTSTest/${table}.bcp -n -S localhost -U gpspl -P yW2S6KXdY8"
    Start-Process bcp -ArgumentList $fmtOut -Wait
    Start-Process bcp -ArgumentList $bcpOut -Wait
}

New-Item -ItemType Directory -Force -Path bcp/AlexisPTSTokenTest
$tables = @("dbo.PANTokenMapping", "dbo.PriToken", "dbo.PubToken")
for ($i=0; $i -lt $tables.length; $i++) {
    $table = $tables[$i]
    $fmtOut = "AlexisPTSTokenTest.${table} format nul -f bcp/AlexisPTSTokenTest/${table}.fmt -n -S localhost -U gpspl -P yW2S6KXdY8"
    $bcpOut = "AlexisPTSTokenTest.${table} out bcp/AlexisPTSTokenTest/${table}.bcp -n -S localhost -U gpspl -P yW2S6KXdY8"
    Start-Process bcp -ArgumentList $fmtOut -Wait
    Start-Process bcp -ArgumentList $bcpOut -Wait
}