Subject Re: [ib-support] keeping current "standby" data
Author Nando Dessena
Bernahrd,

> Shadowing can occur only to a local disk. Shadowing to a NFS
> filesystem or mapped drive is not supported.
>
> Is this information correct?

It is, shadowing is a local mechanism. And, while we're at it, it is
technically possible to have a UDF connect to a *different* db to
execute replica SQL statements. I wouldn't do it that way, though. Since
a UDF runs in the process space of the server, I am for keeping them as
simple and robust as possible.
You could use a replication solution like IBReplicator or even develop
your own. The ingredients are triggers, POST_EVENT and a server side
application that wakes up on the events (or just polls the source DB)
and applies the deltas to the target DB. Like I said before,
IBReplicator offers all this and more out of a reasonably priced box.
Ciao
--
____
_/\/ando