Powershell Script - SQL Server - To script my database objects. -- 2

I need someone to write PowerShell script for SQL Server (using SMO). The script should be scheduled on the server and then run periodically (or by running the script file). Background: Our development team is using SQL Server database. At times they make changes in Table structures, Views, Stored Procedures and Functions. I want to record these changes in GitHub on daily basis. (GitHub portion is not part of this project). Expectation: - A powershell script file will be executed daily that will connect to a SQL Server and will perform following activities (based on a Configuration Criteria). - Script the structure of all tables based on a specified search criteria, as stored in the configuration file. (For example Script the tables starting with “ABC_”). - Script the data of all tables based on a specified search criteria, as stored in a configuration file. (For example: Script the all tables starting with names like “%data%). - Script views based on filter criteria (e.g. Script Views starting with “DEF”). - Script Stored Procedures with names as per search criteria - Script Functions with names as per search criteria. - Keep all variables to be configurable (e.g. Path to create Scripts, Database Connection String info etc. idea is that these variables can be updated at the top of PowerShell file (or in a separate configuration file). Starting Point: - To give you a starting point, following scripts works perfectly on my SQL Server. It scripts the structure and data of 1 table. I want to do similar things on full collection based on Filter criteria. You can use it as a starting point of your code. << Code block begins>> [[login to view URL]]::loadwithpartialname("[login to view URL]") | out-null $BasePath = "C:\Users\myName\Documents\MyScripts"; $FileName = "$BasePath\[login to view URL]"; $Server = "MY-DB" $Database = "MY_DEV" $TableName = "MY_Configuration" $srv = New-Object (‘[login to view URL]’) $Server $so = New-Object('[login to view URL]'); $s = New-Object('[login to view URL]') ($srv); If (Test-Path $FileName) { del $FileName; } $TableList = $[login to view URL][$Database].Tables; $[login to view URL] = 1; $TableList | ?{$[login to view URL] -eq $TableName} | %{ $[login to view URL]($_) | Out-File "$FileName" -Append; $[login to view URL]; } << Code block ends>>