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!

Just trying to be lazy really,
Ian