Re: simple reverse engineering of schema using table and column comments
- From: Marc Slemko <identd@xxxxxxxxx>
- To: Jared Still <jkstill@xxxxxxxxx>
- Date: Tue, 16 Nov 2004 22:16:56 -0800
It is exactly because it is so easy that I figure someone should have
done it and there is no need to reinvent the wheel. <g> But yes, if
not then I'll look at doing it myself, another option there is
outputting it in XML and using XSLT to transform it into HTML.
Thanks for the comments everyone, I'll take a look at the options suggested.
I want this to be something that is easy to script as part of an
automated job, etc. so anything that requires manual steps or
interacting with a UI isn't very attractive.
On Tue, 16 Nov 2004 10:51:07 -0800, Jared Still <jkstill@xxxxxxxxx> wrote:
> This would be fairly easy to do your self with some basic
> data dictionary queries, sqlplus and 'SET MARKUP HTML ON'.
>
> HTH
>
> Jared
>
>
>
>
> On Mon, 15 Nov 2004 23:00:57 -0800, Marc Slemko <identd@xxxxxxxxx> wrote:
> > Does anyone have any pointers to any tools that can take a schema with
> > comments (added by "comment on", visible in "user_col_comments", etc.)
> > and reverse engineer it into a simple document describing table and
> > column types, constraints and comments, etc.?
> >
> > I'm not really looking for a full blown modelling tool (although
> > references to ones that can create or reverse engineer descriptions
> > from Oracle comments would still be useful), but rather something more
> > along the lines of some scripts that spit out HTML or some such.
> >
> > I'm trying to put together a small incremental step beyond the "well,
> > here is the DML used to create the tables, that is all the
> > documentation there is" level of data modelling without requiring much
> > effort or requiring tools for developers to maintain it beyond a text
> > editor. Using Oracle's comment for descriptive information on tables
> > and columns seems like a potentially reasonable first step.
> >
> > Thanks for any suggestions.
> > --
> > //www.freelists.org/webpage/oracle-l
> >
>
>
> --
> Jared Still
> Certifiable Oracle DBA and Part Time Perl Evangelist
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
