Geek Answers Handbook

Need support for .NET versions with a script version.

I look at version control databases and stumbled upon regular articles on how to do this (coding horror, code ode, etc.). All of this makes sense to me, however, I'm trying to find a script runner that will run sql scripts for me. All these articles mention that they need to start something automatically, but none of them gives any recommendations.

Does anyone know any utilities to run these scripts? Ideally, it works as follows:

  • Runs everything in a transaction, so if any one update doesn’t work, it all doesn’t work
  • I have control over the name of the database table schema version.
  • The ability to have a series of scripts that always run if an update occurs

  • Can be run as part of an automated task.

    EDIT

  • Open source

+5
source share
2 answers

Abandon SSW SQL Deploy - it seems to do whatever you ask. It keeps track of already executed scripts, it runs a whole batch of scripts at once and on several servers (if required), etc.

alt text

This is a fairly simple but great tool - highly recommended!

+5
source

We use DbUp as a Script Runner in our web project. Its simple and enjoyable open source tools to help you write your own Script runner with the Console Application mod.

DbUp - .NET, SQL Server . , SQL- , , .

.

github.

http://dbup.github.com

+7

More articles:


All Articles