1. is there a way to retrieve the whole structure of a db (eg all table
structures, all constraints, all indexes, all SPs, etc) and store it into a
file ?

2. is there a way to compare the structure file with another database and
find the differences ?

TYIA

Duilio Foschi

1)Yes.
My application is BDE based, but for table duplication I'm using IBExtract
(IBX 4.2 with Delphi5 ). You can extract to a tstringlist table definitions,
views, index and so on....

2) You have a list of strings now.... so you can compare them.

Good work

Paolo