A utility to run sql files in a specific order [closed]

Question

I'm looking for a tool that will allow the user to add sql file(s) to be run in a specific order against a specific DB. Right now the process is very manual by opening the SQL file and hitting F5... I'm thinking there has to be a more automated way of doing this.

Anyone know of any tool that exists like this?

Answer 1

http://www.red-gate.com/products/dba/sql-multi-script/

RedGate SQL Multi-Script

We use it to great effect in our environment.

Answer 2

You can write a program (e.g. C# on Windows) or a script (e.g. ksh on Unix) to do this. You could then schedule it using your OS scheduler (there are many 3rd party tools for scheduling some are free). The above is quite possible at least for Windows and Unix. I recommend that your program/script keeps track of before and after activities in a log file and clearly checks dependencies before a job starts (if you need this type of actions in your system). Databases such as Oracle and most ETL software provid schedulers that are also customizable for such tasks. Make sure that the no one turns that server down though :)

Answer 3

Liquibase is .. "for tracking, managing and applying database changes. It is built on a simple premise: All database changes are stored in a human readable yet trackable form and checked into source control."

Basically it looks like this:

<changeSet author="bob" id="BUG-1234>
 <sql>
  INSERT INTO ...
 </sql>
 <sql>
  ALTER TABLE ...
 </sql>
 <sql>
  DROP INDEX ...
 </sql>
</changeSet>
<changeSet author="peter" id="BUG-1235>
 <addTable ...>
 <modifyDataType ...>
 <addColumn ...>
 <dropView ...>
</changeSet>