Database Versioning

[Craig Boyd]

Hello All,

I am not sure if this is the proper place for this topic, but I have to start somewhere....

How do you guys / gals handle database versioning?

In other words, you have a database that has changes going into it. How do you version the changes and keep track of what changes have been pushed to where?(From Dev to Unit to Integration etc...)

Thanks,

Craigbert

[Paul Sturrock]

By changes do you mean DDL changes rather than data? We handle those using PowerDesigner - its a bit cumbersome, but pretty good at merging differences between schemas. Generated (database specific) scripts to produce the physical model are tagged in SVN as they are promoted from dev to test to release.

[Craig Boyd]

Paul, thanks for the response. Yes, I do mean DDL changes.
I am familiar with PowerDesigner. I have used ERwin in the past which also does a decent job. But both of those products are VERY pricey. Anything less expensive?

[Paul Sturrock]

I've not used any open source alternatives I'm afraid.

[Craig Boyd]

Fair enough. Has anyone used an open source tool to handle this or less expensive one? (Both PowerDesigner & ERwin cost in the thousands for a single seat.)

Thanks,

Craigbert