Josh Gilfillan jgilfillan
kitroed
/ GenerateSqlScripts.ps1
Last active
December 23, 2022 22:28
Generate a file-per-object representation of a given SQL Server database using PowerShell and SMO.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| # Adapted from http://www.simple-talk.com/sql/database-administration/automated-script-generation-with-powershell-and-smo/ | |
| <# | |
| .SYNOPSIS | |
| Generate file-per-object scripts of specified server and database. | |
| .DESCRIPTION | |
| Generate file-per-object scripts of specified server and database to specified directory. Attempts to create specified directory if not found. | |
| .PARAMETER ServerName |