> We would use the embedded database, however our application connects to
> two databases simultaneously: one is remote, one is local...
>

then you haven't asked the right questions at the right time. Embedded gives
you exactly that ability. Connect to both a local embedded database AND a
remote one at the same time.
You cannot do cross DB joins though.
Alan