Do you have Redgate licences? If so using the tools recommended above should work well. Redgate will work out the upgrade script for you so you don't need to write it yourself. I've documented one way to do it here, although there are other ways. This way, for example, assumes you use Redgate SQL Source Control:http://workingwithdevs.com/database-ci-with-jenkins-a-step-by-step-tutorial/
Redgate can also include your static/reference data. However, if you want to deal with larger amounts of data you could use something like SQL Data Compare command line or SSIS.
However, it sounds like you want something to just run some SQL files that you want to write yourself. In this case it is worth looking at something like ReadyRoll (by Redgate), DBup (open source) or FlyWay (open source). That said, this approach does have it's drawbacks.
If you are looking for tooling you should ask yourself, do you intend to work with the state of the database (with tools like the Redgate SQL Toolbelt or SSDT) or do you want to work with upgrade scripts (ReadyRoll, DBup, FlyWay etc).
Generally working with scripts, as you suggest, provides more control but also more complexity. I've tried to explain in more detail here:http://workingwithdevs.com/delivering-databases-migrations-vs-state/
If you'd like more support get in touch. www.dlmconsultants.com