Application A uses database A.
Application B uses database B.

Currently some data - routinely entered into database A - is printed,
then manually re-entered into database B.

The task is to find a way to trasfer this data automatically from
database A into database B (after some processing).

Ideally the trasfer should be immediate, using the After Insert/After
Update triggers in database A, but I doubt that this is possible.

In practice, an acceptable solution would be to write all
updated/inserted/deleted data into an external file.

When the user of application B click a given button, data is read
from the external data and written into database B.

Before I dive into code, does somebody know a better solution ?

TIA

Duilio Foschi