I'm pretty much sold on to the Agile practice of refactoring. However many times I've wondered if this concept can actually be applied out of the typical coding context and to contexts like database design. Wouldn't refactoring databases involve a lot of effort since a LOT of data would have to be migrated to the new schema, not to mention that any change in schema would require a change in code that makes SQL references to that schema?
I recently ran into an article on Database Refactoring. Haven't gotten to reading it yet; I'm hoping it'd provide me with some answers.
I'll document what I find...
Still haven't read the above article, but found another one that I wanna read!
Here it is:
Evolving Database Schemas