> >
> > I don't think this same set of commands can be generated for FK/PK
> changes.
> > If field dropping is required then re-population of data is required
> also -
> > seems to me to be something a manual approach would provide more
> comfort on.
> >
> > That said, if you are upsizing a field, it's likely that just
> upsizing all
> > related fields (dependent on it) would be enough. Followed by a
> backup
> > restore cycle and perhaps all this done on a test copy first, until
> the
> > script is all sorted.
> > Alan
> >
>
> That's a point!
>
> Is the backup file in a pseudo readable form? What is a backup was
> taken, the
> required fields changed in the backup file itself, then restored and
> tested?
>
> It then handles the re-construction and re-creation of all constraints,
> triggers, procedures, etc...
>
> ...jsut a thought.
>
> N.

you can't edit backup files (not that I'm aware of) unles you know how.
Admin tools don't access fbk files.
You need to edit the real thing. A B/R cycle ensures integrity.
Alan