I am looking for a developer to achieve 2 things.
1. PowerShell script to connect to SQL server, grab the schema of the database and export it to a SQL script. the PowerShell script should exclude some of the tables, some SPs, few functions, all assemblies and users.
The PowerShell script will run on the same server as the DB is hosted. The script will have to run from C:\DBScriptGenerator\ (we should have the flexibility to change this path time to time). The output SQL script should get generated onto the same c:\DBScriptGenerator\[login to view URL]
2. PowerShell script to connect to the same SQL server and generate SQL script that will include certain tables with data. Output should get generated as c:\DBScriptGenerator\[login to view URL]
Please see the attached document for more details.