Click here to Skip to main content
12,621,302 members (30,283 online)
Click here to Skip to main content
Add your own
alternative version

Stats

17.1K views
335 downloads
19 bookmarked
Posted

Osql Batch Scripter

, 15 Nov 2006
Rate this:
Please Sign up or sign in to vote.
Modification of the Osql Batch Scripter
<!-- Article Starts - DO NOT ADD HTML/BODY START TAGS-->

Sample Image - Osql_Batch_Scripter.gif

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.

License

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

Share

About the Author

F.E.A.
Web Developer
Canada Canada
No Biography provided

You may also be interested in...

Comments and Discussions

 
-- There are no messages in this forum --
| Advertise | Privacy | Terms of Use | Mobile
Web02 | 2.8.161128.1 | Last Updated 15 Nov 2006
Article Copyright 2006 by F.E.A.
Everything else Copyright © CodeProject, 1999-2016
Layout: fixed | fluid