Powershell Scripting: Automated scripting of database DDL

Make use of Sql server Management Object using Microsoft.sqlserver. This can be added as reference in powershell script as given below. If you are DBA and want to read schema for that matter any automation. You can check the commands within SMO object.

References:

https://www.simple-talk.com/sql/database-administration/automated-script-generation-with-powershell-and-smo/

http://www.sqlservercentral.com/Forums/Topic1167710-1550-1.aspx#bm1168100

http://www.sqlhammer.com/blog/t-sql-command-line-options-part-5-sqlps/

http://stackoverflow.com/questions/483568/how-can-i-automate-the-generate-scripts-task-in-sql-server-management-studio-2

http://www.sqlhammer.com/blog/t-sql-command-line-options-part-4-sqlpsx/