Ian,

> Is there a very simple way to merge 2 databases with completely
> different structures including the data?
>
> We have 2 separate apps working off 2 databases that slowly over time
> have been used for related tasks and now the users and admins want to
> treat them as one, with queries across them both. There should be no
> conflicts in the structures. We have scripts to extract data, create
> metadata and then re-import data but this takes a fair amount of time
> due to the sizes, but it is a sensible proposition. I just wondered if
> there was a quicker/easier/tidier way to do this rather than just
> brute-force, similar in complexity to the old paradox way!

What would be the "old paradox" way?


As far as I can tell - there's no other way but creating the metadata
and using a datapump. Why is this "slow"?


With regards,

Martijn Tonies
Database Workbench - the developer tool for InterBase & Firebird
Upscene Productions
http://www.upscene.com

See you at the First European Firebird Conference in May in Fulda, Germany
http://www.firebird-conference.com