DBREMOTE with selective publications

[Baron]

Is there any way to start DBREMOTE so that it replicates only specific publications? Something like the option -n in DBMLSYNC.

[VolkerBarth · Accepted solution]

AFAIK, no, there is no such option.

DBREMOTE sends and/or receives modifications for all according publications. IMHO, that is a design choice and does manifest in the fact that the according SYS.SYSREMOTEUSER table stores the sent/received transaction log offsets per remote database, not per publication. – In contrast, MobiLink does manage those per publication, cf. SYSSCYNC/SYSSYUNC2.

[Baron · Accepted solution]

Thanks, this was also my point, I wanted just to get a confirm.

[VolkerBarth · Accepted solution]

Well, "AFAIK":) - possibly Reg has some smart workaround?