I have been playing with Daffodil API (Replicator, JDBCDataSource,
Subscription etc.) for a little while and its seems to work quite
well, however, I have two questions.
I am replicating table T from a source database (DB2) to a target
database (Postgres) - i.e. trivial unidirectional replication. The
replicated table T is in in schema S in the source database.
1. Is there a way to make Daffodil replicate the table to a different
schema in the target database? Currently it seems that I must have
schema S in the target database which is not good - I want tables from
multiple sources to end up in a particular target schema regardless of
what source schema they come from.
2. If there a way to force Daffodil to initially populate the replicas
(target tables) with _all_ data from the source tables? In my case,
Daffodil replicates only the changes, which is fine, but before it
starts replicating the changes, I would like Daffodil to create a copy
of the replicate table in the target database. Once the copy is there,
it can only replicate the changes.
Thank you,
Jan Moravec