Jeremy wrote:
>
> The question remains - why is it a "mess" and should not be permitted in
> a production environment? I genuinely want to know and consider that a
> statment such as "DDL should be run by a DBA, not by application code"
> doesn't provide any kind of answer.
I guess it depends on your release procedures. In my opinion, a
production system should be built by running the various object
creation scripts against the database. Letting the application add
database objects will ruin your audit trail. What if you need to build
an exact copy of the database for, say, testing purposes or DR?
Because your database isn't adequately documented (ie. you don't have
the scripts required to recreate it), you cannot build a new
environment but merely copy the existing database. This may be
acceptable to your business; I assume you're a Windows site?
Received on Wed Mar 29 2006 - 06:34:48 CST
