Just a silly idea, because I use it all the time.

Build a clean blank database and pump the data into it.

I use IB_WISQL take the source from that ( when I don't have
proper documentation ) and create a clean database, then the
pump function completes the picture. It also allows you to
tidy up the other bits that have been left over time.

I recoment this approach when ever major changes are planned
as well. The target is disposable, and any problems can be
tackled in the pump SQL.

I think there has been a lot of time wasted on implementing
changes direct on the database when a simple copy will do
the job. I know that the pumps can take time, but fixing
problems can take a lot longer <g>

--
Lester Caine
-----------------------------
L.S.Caine Electronic Services