Question:
I have five .sql files and know the name of each file. For this example, call them one.sql, two.sql, three.sql, four.sql and five.sql. I want to append the text of all files and create one file called master.sql. How do I do this in PowerShell? Feel free to post multiple answers to this problem because I am sure there are several ways to do this.
My attempt does not work and creates a file with several hundred thousand lines.
1 2 |
PS C:\sql> get-content '.\one.sql' | get-content '.\two.sql' | get-content '.\three.sql' | get-content '.\four.sql' | get-content '.\five.sql' | out-file -encoding UNICODE master.sql |
Answer:
1 2 |
Get-Content one.sql,two.sql,three.sql,four.sql,five.sql > master.sql |
Note that
>
is equivalent to Out-File -Encoding Unicode
. I only tend to use Out-File when I need to specify a different encoding.