Thanks both Alexandre and Carl :) Fortunately we don't have any
triggers,
and the views don't use any SPs, so that's a few dependencies
less :) Since
the previous design was not properly normalized, we had to
revamp it almost
completely, so dependency-wise it's not too complicated right
now. However
since this design will remain stable now, with only a few
additions as per
feature requirements, we shall soon look towards adding triggers
and
introducing more constraints in the near future. Your advice
will surely be
useful at that time.

Yes, I have documented the table design, but not the SPs and
Views. It's
easy but time-consuming, and as always, we are short of time :(
I am using
a freeware tool IBExpert (Personal Edition) and it does show the
dependencies of an object as also the metadata, so that's not a
problem for
me.

What I would like to know more if I were to create a separate
database
containing the new structure, say DBNew, and I wanted to use a
few SPs to
copy data from the old database, say DBOld, into the DBNew,
would it be
possible and how? Then I could create the new structure in a
separate GDB
file, copy all the old data, and then simply delete the old GDB
file and
rename the new one. I just am not sure if I can do this easily
from within
SPs written in DBNew, or would I need to use my application to
perform the
data transfer.


Anand

21. Re: Upgrading a database
From: Alexandre Benson Smith
<iblist@...>


23. Re: Upgrading a database
From: "Carl Peto" <carl@...>



__________________________________
Do you Yahoo!?
Yahoo! Finance Tax Center - File online. File on time.
http://taxes.yahoo.com/filing.html