Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Database Versioning

 
Craig Boyd
Greenhorn
Posts: 21
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Bartender
Posts: 10336
Eclipse IDE Hibernate Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Greenhorn
Posts: 21
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Bartender
Posts: 10336
Eclipse IDE Hibernate Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I've not used any open source alternatives I'm afraid.
 
Craig Boyd
Greenhorn
Posts: 21
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic