SimpleScriptRunner can be used to run a directory of numbered sql scripts against an MSSQL database. The tool can easily be extended to run against other versioned objects. This is very handy if you are maintaining multiple database environments (e.g. dev, test, production) or working in a team.

The tool will only execute scripts with higher numbers than have been previously executed - i.e. if the last script to be applied was script 0003, scripts 0004 and onwards will be applied - with one exception. If the last script to be applied has been modified since it was last executed, it will be executed again. This is handy if you are working on a script and need to make slight changes to it. The tool will also create the database on the server if it does not exist.

The usage for is
SimpleScriptRunner.exe <serverName> <databaseName> <path to folder containing sql scripts> [options]

or for SQL Authentication
SimpleScriptRunner.exe <serverName> <username> <password> <databaseName> <path to folder containing sql scripts> [options]

the sql scripts should start with the script version number and then a space, and be grouped into numbered Release folders.

The license of this software is Free, you can free download and free use this database management software.