Command line version


SQLrunner should allow users to execute SQL scripts from the command line so it can be incorporate to build scripts or batch commands.
Closed Sep 24, 2007 at 9:27 PM by ealbert
This feature is ready for the release.


indyl wrote Sep 21, 2007 at 9:02 AM

I've been able to create a little batch file with the following simple one line of code that executes the scripts against a database.

FOR %%F IN (*.sql) DO sqlcmd -S database -i"%%F"

ealbert wrote Sep 24, 2007 at 9:26 PM

That is a valid approach to the problem, however it does not perform well as it opens one connection to the server for each script. The SQL Server solution performs much better and the user also obtains a detail report of the execution.

wrote Sep 24, 2007 at 9:27 PM

wrote Sep 17, 2009 at 4:28 AM

Associated with changeset 36758.

wrote Feb 14, 2013 at 12:03 AM

wrote May 16, 2013 at 6:01 AM