Subject RE: [firebird-support] TMP$STATEMENTS - field "sql" in firebird ?
Author Alan McDonald
> I tried to use some replicators, but all are using dialect 3. If I
> change the dialect in the merchandise information system from 1 to 3 it
> stops working. That is one problem with the replicators. Another problem
> is, that they dont use encrypted connections so far as I can see.
> The last big problem is, that I have to integrate the configuration into
> the merchandise information system. All that is not really wise possible
> with an existing replication system.
>
> My idea is to create an additional table, in which a trigger fires the
> datasets in that have changed (insert,update,delete). I want to update
> only the exact change of a dataset, not the hole one. Thats why I need
> the field-NAME of the field that changed in the dataset.
> An external skript is reading this tabel and updates every dataset
> through a ssh-connection. I wrote a server and a client for the
> datatransfer wich uses a ssh-tunnel. On the other side the dataset is
> written into the database through the server. Some tables have to be
> bidirectional updated, but only some.
>
>
> Andi

if you use the old ReplManager which can be found here:
http://www.meta.com.au under the previous versions of FBReplicator.
It uses dialect 1 only.
If you set up Zedebee as your proxy, then the replication traffic will be
encrypted.

Alan