Marshall wrote:
> Andrew McDonagh wrote:
>> phlip wrote:
>>> Andrew McDonagh wrote:
>>>
>>>> As for refactoring, most of the difficulty comes down to the limitations
>>>> of the store procedure language and development environments not
>>>> supporting automated refactorings.
>>>>
>>>> Its possible, just difficult and manual.
>>> I thought the hard part was upgrading live user data on the fly.
>>>
>>> Sounds like another reason for careful partitioning ;-)
>>>
>> without taking the system offline its certainly hard, otherwise its not.
>
> Agreed. It is noticably easier to do if the system is offline, but
> I have myself performed *many* schema updates to an enormous
> mission critical database without taking anything offline.
>
>
> Marshall
>
Yep - we do it all the time - its do-able - just harder than offline
working.
Received on Fri Jun 02 2006 - 17:49:45 CDT
