Sybase SQL AnyWhere - Replication and Triggers

[Oded Szpiro]

Dear sirs,

I have currently a replication running between two sites, using SMTP
protocol.
The PCs and site servers all run: Win NT 4.0 SP6a, SQL Any ASA version
5.5.05 Build 2817.

There could be a need, in the near future, to change the contents of one of
the triggers, in the database and run/execute it.

Do I have to stop the replication, scrap it, copy the modified hq.db file
from the master to the slave site and re-create the whole replication for
this?

Thanks in advance,

Oded
od...@travelcafe.org

[Oded Szpiro]

Hi Ian,

Sorry, but I do nto understand the passthrough fully.

May I, sort of, think aloud.

At the master site, I modify the trigger and execute it on the local
database. However, the contents of the trigger must have:

passthrough for remoteuser;

trigger statements;

Passthrough stop;

Will the above be replicated and the new/modified trigger will be created
also at the remote site?

what happens later at the master site, when the application, written in
NetPlus 3.5 puts data in the local database and the trigger is actioned?
After one replication send do I have to remove the passthrough for
remoteuser and passthrough stop from the trigger.

The replication manual, top of page 268, says that:

By default passthrough mode statements are executed at consolidated as well.
What does this mean?

Thanks,

Oded
"Ian Bater" <ibater...@sybase.com> wrote in message
news:3C9B17DD...@sybase.com...
> Hi Oded,
> No you do not have to do that. You can accomplish all this through
> passthrough mode without interupting your current replication environment.
> Passthrough mode is well documented in the manual.
>
> Cheers
>
> Ian Bater
> iAnywhere Solutions

[Ian Bater]

Hi Oded,
No you do not have to do that. You can accomplish all this through
passthrough mode without interupting your current replication environment.
Passthrough mode is well documented in the manual.

Cheers

Ian Bater
iAnywhere Solutions

[Robert Waywell]

No, use a PASSTHROUGH session to send the new trigger definition down to the
remote database.

--
-----------------------------------------------
Robert Waywell
Certified SQL Anywhere Associate
Sybase's iAnywhere Solutions

Please respond ONLY to newsgroup

EBF's and Patches: http://downloads.sybase.com
choose SQL Anywhere Studio >> change 'time frame' to all

To Submit Bug Reports: http://casexpress.sybase.com/cx/cx.stm

SQL Anywhere Studio Supported Platforms and Support Status
http://my.sybase.com/detail?id=1002288

"Oded Szpiro" <od...@travelcafe.org> wrote in message
news:rWK#HOc0B...@forums.sybase.com...