Concatonate multiple SQL files with Powershell

I have a lot of separate SQL files that I wanted to put together. In addition they needed a ‘GO’ operator between each one. Here is my basic Powershell command:

get-childitem -filter “*.sql” | foreach-object { Get-Content $_ | Out-File -filepath “MyBigSchema.sql” append; “Go “ | Out-File -filepath “MyBigSchema.sql” -append }

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s