ForEach-DB

1.56

This script executes all commands in a .sql script file in all databases
present in the specified SQL instance. It has the ability to produce a single output file in any of
multiple supported formats (CSV, TAB delimited, Pipe delimited, XLSX, JSON, XML) or pump the data
to a single table in a specific server in a specific database.

Minimum PowerShell version

5.0

Installation Options

Copy and Paste the following command to install this package using PowerShellGet More Info

Install-Module -Name ForEach-DB

Copy and Paste the following command to install this package using Microsoft.PowerShell.PSResourceGet More Info

Install-PSResource -Name ForEach-DB

You can deploy this package directly to Azure Automation. Note that deploying packages with dependencies will deploy all the dependencies to Azure Automation. Learn More

Manually download the .nupkg file to your system's default download location. Note that the file won't be unpacked, and won't include any dependencies. Learn More

Owners

Copyright

(c) 2020 Jose Sebastian Battig/Ascentis Corporation. All rights reserved.

Package Details

Author(s)

  • Jose Sebastian Battig

Cmdlets

ForEach-DB

Functions

ForEach-DB IsEmptyString resultSetToDelimited elapsedTime output

Dependencies

FileList

Version History

Version Downloads Last updated
1.56 (current version) 1,367 6/1/2020
1.55 19 5/31/2020
1.54 18 5/30/2020
1.53 19 5/30/2020
1.52 18 5/30/2020
1.51 19 5/30/2020
1.50 23 5/29/2020
1.42 18 5/29/2020
1.41 19 5/29/2020
1.5 18 5/29/2020
1.4 18 5/28/2020
1.2 24 5/27/2020
1.1 20 5/27/2020
1.0 24 5/27/2020
Show more