Re: The fable of DEMETRIUS, CONSTRAINTICUS, and AUTOMATICUS

From: Marshall Spight <mspight_at_dnai.com>
Date: Fri, 22 Oct 2004 01:59:00 GMT
Message-ID: <EPZdd.293253$D%.166424@attbi_s51>

"Laconic2" <laconic2_at_comcast.net> wrote in message news:DJadnbrwrt5efOrcRVn-jw_at_comcast.com...
>
> BTW, one of the features of DEC Rdb/VMS that I used to like was the
> "$RMU/EXTRACT" feature.
>
> This command would examine the system tables of a database and create an
> entire CREATE script that would
> create the database, and all the CREATE commands needed to set up database
> objects, schemas, and schema objects inside it. The create script was SQL
> DDL (DEC Rdb dialect). So "reverse engineering" an Rdb database was like
> shooting fish in a barrel, if you knew how to RTFM.

Now, if we have a catalog, why can't we just dump the catalog and insert *that?* Metadata is still data.

It seems to me that DDL must at all times be considered simply as a shortcut for doing DML on the catalog.

Marshall Received on Thu Oct 21 2004 - 20:59:00 CDT