How do you manage schema upgrades to a production database?

Posted by Mark Harrison on Stack Overflow See other posts from Stack Overflow or by Mark Harrison
Published on 2008-08-27T08:36:37Z Indexed on 2010/05/22 2:20 UTC
Read the original article Hit count: 224

This seems to be an overlooked area that could really use some insight. What are your best practices for:

  • making an upgrade procedure
  • backing out in case of errors
  • syncing code and database changes
  • testing prior to deployment
  • mechanics of modifying the table

etc...

© Stack Overflow or respective owner

Related posts about Oracle

Related posts about database-administration