• Blowing the trumpet for Powershell and SQLPSX.

    You can use a scriptingoptions object to make the script output configurable.

    Get-SqlDatabase -dbname test -sqlserver server | Get-SqlTable | Get-SqlScripter | Set-Content -Path C:\script.sql

    Get-SqlDatabase -dbname test -sqlserver server | Get-SqlStoredProcedure | Get-SqlScripter

    Get-SqlDatabase -dbname test -sqlserver server | Get-SqlView | Get-SqlScripter