Need a powershell script to write a script to do the following:
1) go to a c:\deploy\ToBeDeployed\ folder
2) loop through all the .zip files in the folder
2a) extract all the .sql files from the zip file
2b) execute the .sql file one by one using Invoke-cmd on to the local SQL server instance
2c) Continue with next script if any script throws error.
2d) Log the error in a simple text file within the ToBeDeployed folder
3) MOVE the .zip file to c:\deploy\Deployed\ folder
Attached is the folder with the sample files to be tested.
Anybody who knows Powershell should not take more than an hour or so to be doing it, so I expect to have this done within the day of awarding it and the budget is £ 50.00