Re: [Springframework-developer] Schema and DB Migration Best Practices

[Ulrik S. <ulr...@ja...>]

I have previously used the modelling tool
ERwin<http://www.ca.com/us/products/product.aspx?ID=260>for
maintaining databases. Its modelling features were awsome, but it also
had a powerful compare functionality that proved to be extremely useful. It
could compare model to model, model to physical database, database to
another database, as well as database to model. From the generated diff, I
could then choose to apply the changes and make the two sides equal. The
strongest feature, however, was the ability to generate a SQL script from
the diff that applied the changes to a database while keeping the data
intact. We used this feature to take diffs between the new version and all
of our released versions. These scripts could then be applied to the
customer database when we were upgrading from any released version to the
latest. Superb tool. This was a while ago, though, and I don't know if it
still lives up to this.


On 8/31/07, Jan Nielsen <jan...@gm...> wrote:
>
> Hello,
>
> I'm new to Spring - my apologies if this is a bit pedantic. I've been
> reviewing how to implement schema and data evolution in a new
> Spring-based application using Hibernate (I'm also new to Hibernate),
> as well as migration of existing production data into the new DB.
> Surprisingly, I found very little relevant in a Nabble search of
> Spring's developer and user archives. And I found nothing in the
> Spring documentation. Perhaps "Schema migration", "DB migration" are
> the wrong terms for Spring applications?
>
> I'm clearly not the only one facing issues of schema and data
> migration and evolution in Spring applications. Are there any best
> practices, support, existing tools, thoughts, etc.? For example, using
> Spring's Hibernate support, where/when should table creation be done?
>
> So far, I've found a few different solutions:
>
>   -LiquiBase (I have not used it yet)
>   -few different home-grown Spring framework plug-ins
>
> Any thoughts, corrections, re-directs, etc. are greatly appreciated.
>
>
> Many thanks,
>
> -Jan
>
> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Splunk Inc.
> Still grepping through log files to find problems?  Stop.
> Now Search log events and configuration files using AJAX and a browser.
> Download your FREE copy of Splunk now >>  http://get.splunk.com/
> _______________________________________________
> Springframework-developer mailing list
> Spr...@li...
> https://lists.sourceforge.net/lists/listinfo/springframework-developer
>
>


-- 
Ulrik