How input a file data for command in windows powershell/cmd

Question

I am trying to run a BCP command in windows machine powershell and unable to give input from a sql file.

Below command works fine in my MAC and I am looking for the same for Windows machine.

bcp "$(< /Users/mahendra.hegde/Desktop/input.sql)" queryout /Users/mahendra.hegde/dataout.json -c -T -S sample.env.compxyz.com

input.sql file scripts should be passed as input to bcp command when it runs.

I tried many ways in Windows but did not work, any help would be appreciated

Thanks

This is in bash on the Mac? If so, please provide a breakdown and explanation of what it's doing. — Jeff Zeitlin
– Jeff Zeitlin, Commented Mar 8, 2021 at 18:16
Are you just reading the content of a file? please be clear on what you want to achieve — Isaac
– Isaac, Commented Mar 8, 2021 at 18:20
What did you search for? 'bcp powershell' --- What have you tried? What happened? • PowerShell: Running Executables. There are modules to work wiht SQL via teh MS powershellgallery.com. Find-Module -Name '*sql*' | Format-Table -AutoSize — postanote
– postanote, Commented Mar 8, 2021 at 18:30
SO does have rules we are told to follow: Provide MRE --- How to ask --- Don't ask --- Proper Topic --- Why not upload images of code/errors? --- format your post properly: — postanote
– postanote, Commented Mar 8, 2021 at 18:31

mklement0 · Accepted Answer · 2021-03-08 19:35:45Z

2

The equivalent of this bash command:

bcp "$(< /Users/mahendra.hegde/Desktop/input.sql)" queryout

is this PowerShell command:

bcp (Get-Content -Raw C:/Users/mahendra.hegde/Desktop/input.sql) queryout

Both commands pass the content of the specified file as a single, multiline string to the bcp utility; see the Get-Content cmdlet's documentation.

However, as of PowerShell 7.1, due to broken passing of arguments with embedded " characters - see this answer - more work is needed if the .sql file contains " characters; in the simplest case:

bcp ((Get-Content -Raw C:/Users/mahendra.hegde/Desktop/input.sql) -replace '"', '\"') queryout

edited Mar 8, 2021 at 19:35

answered Mar 8, 2021 at 18:51

mklement0

452k68 gold badges728 silver badges988 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How input a file data for command in windows powershell/cmd

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related