Re: Function tracking

Rebecca Clarke wrote on 07.06.2013 12:30:
> I'm looking for suggestions on the best way to track the updates to a
> function.
>
> We have two databases, Dev & Live, so I want to update Live with just
> the functions that have been modified in the DEV databas3e. Is there
> another, easier way to track the updates than manually recording it
> in a document? (I'm trying to eliminate human interference).

We are pretty happy using Liquibase for all our schema migrations.

For stored procedures/functions it's best to use a changeSet that includes a SQL file
and is marked as runOnChange=true

The Liquibase changelog files are then stored in Subversion.
A little shell script applies the changes to any environment we want

Thomas