I am writing this blog for one on my colleague Kallidile, Sujith who wants to do this task for his Production Deployment repeatedly. This is also dedicated to all DBA team who are also doing same.
To solve this problem, I have created a batch file which will read all SQL files from folder excluding child folder and use SQLCMD to execute scripts file to specified Data Source.
How to run batch file ?
1. Copy batch file “ReleaseSQLServerScripts.bat” to location from where you want to release SQL files.
2. Click on “ReleaseSQLServerScripts.bat” to execute batch file.
3. Batch file will ask Server Name where you want to deploy your scripts.
Below is the batch file to download.
- We are using window authentication for deployment.