Introduction
This is a small tool that will scan a selected folder for all the .sql files and generate a MS-DOS batch script that will execute the scripts on a selected server/database.
This utility is the modification of the tool from Michael Erasmus.
http://www.codeproject.com/cs/database/osqlScript.asp
I have added a few modifications, bug fixes and possibilities to this utility.
The latest build can always be found on http://f-e-a.atspace.com
New capabilities
Here is a quick list of the added capabilities:
- Remembers last parameters that were used to build a script.
- Option to use the timestamp in your script (useful for server downtime estimation)
- Exclusion List excludes the .sql files mentioned in excluded .txt file (useful for big upgrades where some patches needs to be excluded in case if they were already applied)
Conclusion
This is a very simple but handy deployment tool that I use and I hope that someone else would find it useful.
This article has no explicit license attached to it but may contain usage terms in the article text or the download files themselves. If in doubt please contact the author via the discussion board below.
A list of licenses authors might use can be found here
