Re: Generating DDL From Designer In a Set Order

From: Malcolm Dew-Jones <yf110_at_vtn1.victoria.tc.ca>
Date: 3 Jun 2009 17:23:16 -0700
Message-ID: <4a2713f4$1_at_news.victoria.tc.ca>



S R (sr_ng_at_duz.not.exist.com) wrote:
: Designer Version is 10.1.2.0.2.

: Whenever I generate the schema/ddl creation scripts after making minor
: changes, I like to compare the new scripts against the last set just to
: make sure the changes are as I expect. The trouble is each time I
: regenerate, the order of the items is different each time, making
: comparisons difficult.

: I've tried looking for a setting in the preference sets but there isn't
: anything obvious . Anyone know how to tell it to set the order of the
: tables during generation?

My kludgey work around: I have used something like the following to force a sorted order for comparisons of scripts such as the ones created by designer.

        perl -e "BEGIN{ $/=''} print sort <>" XXX.con .ind .etc

C:> perl -e "BEGIN{ $/=''} print sort <>" sclr.ind > sclr.ind.0

then generate, then

C:> perl -e "BEGIN{ $/=''} print sort <>" sclr.ind > sclr.ind.1

then diff the before and after

C:> diff sclr.ind.0 sclr.ind.1

$0.10 Received on Wed Jun 03 2009 - 19:23:16 CDT

Original text of this message