gps.docker/alexissecuredb/bcpScripts/copyData.ps1

New-Item -ItemType Directory -Force -Path bcp/AlexisPTSTest
$tables = @("dbo.CardManufactureMaster", "dbo.IncorrectUserLogHistory", "dbo.Cards", "dbo.ProductType", "dbo.SchemeMaster", "dbo.Users", "dbo.UserType")
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
}

New-Item -ItemType Directory -Force -Path bcp/AlexisSecure
$tables = @("Encryption.AccountRanges", "Encryption.AccountRangesKeys", "Encryption.CardSchemes", "Encryption.EncryptionTypes", "Encryption.KeyAsymmetricComponents", "Encryption.KeyExpiryActions", "Encryption.KeyFormats", "Encryption.KeyPermittedUses", "Encryption.Keys", "Encryption.KeyStatuses", "Encryption.KeyTypes", "Encryption.KeyUsages")
for ($i=0; $i -lt $tables.length; $i++) {
    $table = $tables[$i]
    $fmtOut = "AlexisSecure.${table} format nul -f bcp/AlexisSecure/${table}.fmt -n -S localhost -U gpspl -P yW2S6KXdY8"
    $bcpOut = "AlexisSecure.${table} out bcp/AlexisSecure/${table}.bcp -n -S localhost -U gpspl -P yW2S6KXdY8"
    Start-Process bcp -ArgumentList $fmtOut -Wait
    Start-Process bcp -ArgumentList $bcpOut -Wait
}