Re: DBA best practices/tools for development process?

> We're on a development project which has recently gone from 2 people to many
> more. As the dba, I'll need to formalize the development procedures--i.e.
> formal database change requests, etc. I'm looking for "best practices" --
> i.e. dba change request forms--plus any scripts that might come in handy for
> documenting and communicating between the devlopers and the dba. (e.g.
> generating a table layout, with comments from Oracle into html, for easy
> browsing).
>
> It's basic stuff, and I could easily come up with procedures and code
> utility scripts myself, but I thought there might be resources out there for
> this type of thing.

You are taking the right steps. But if carried too far you will not only generate your very own hate group but you will slow development to a crawl. Develop the guidelines with the developers so they feel some ownership.

And buy a copy of Designer for documenting and creating ERDs.

Daniel A. Morgan Received on Thu Mar 15 2001 - 05:37:56 CET