Hi,

If I was looking to compare data in two versions of the same database, I
would hook them up using to MS Access using ODBC and do a series of not
matching queries.

It is possible to use SQL queries to populate a new format database from an
old one.

If it is the database structure you want to check out then run a query FO
to a file and try FCOPY compare.

Gerry Reilly wrote:
>
>Hi,
>
>I have an old system with ten different databases in it.
>
>The upgraded system contains many years of database modifications (new
>elements, new data sets etc.)
>
>Does anyone know what would be the best tool/technique to compare an old
>database with a newer one, and to actually load up the new one?
>
>Any suggestions gratefully received!
>Gerry Reilly
>HP South Queensferry
>
_______________________________________________________
Ken Vickers
LINKWAY Development and Support
Computing Solutions Limited
10 St Andrews Road
Droitwich, Worcestershire
UNITED KINGDOM
TEL +44 (0) 1905 794400
FAX +44 (0) 1905 794464
mailto:[log in to unmask] or
mailto:[log in to unmask]