• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

Database Versioning

 
Greenhorn
Posts: 21
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
 
Bartender
Posts: 10336
Hibernate Eclipse IDE Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
Hibernate Eclipse IDE Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
reply
    Bookmark Topic Watch Topic
  • New Topic