Source moved to https://github.com/mcintyre321/SimpleScriptRunner
This tool 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 usage for is
SimpleScriptRunner.exe
[options]
or for SQL Authentication
SimpleScriptRunner.exe [options]
the sql scripts should start with the script version number and then a space, and be grouped into numbered Release folders.
e.g.
Release 1 001 - Create Users table.sqlRelease 1 002 - Create Customers table.sqlRelease 2 001 - Create Items table.sql