I have a pair of synchronized databases using mobilink using shadow tables on cons. side. As long as I know all the changes caused by triggers will not be transfered between databases (are written as comments in transaction log files). For some reason I have all the new entries inserted through trigger this time in both directions replicated. Is this an option?

asked 15 May, 09:54

Sarkis's gravatar image

Sarkis
2002524
accept rate: 0%

You may be confusing SQL Remote behavior with MobiLink behavior.

In SQL Remote trigger actions were not replicated unless you requested them to be included (using a dbremote cmdline switch).

In MobiLink dbmlsync will include all changes from the remote that match the publication whether or not they occur due in a trigger. At the consolidated, all data matching the table download, synchronization scripts will be sent.

I'm not certain why you think you are seeing a change in your synchronization behavior.

(15 May, 14:49) Nick Elson S...
Replies hidden
1

Nick is incorrect. dbmlsync will only send trigger actions if the SendTriggers(st) extended option (http://dcx.sap.com/index.html#sqla170/en/html/81ab5e1b6ce210148dc2aeb67317b748.html) is set to ON. The default is off.

(16 May, 08:57) Reg Domaratzki

thanks for the comment, but the link is invalid.

Sarkis

(16 May, 17:06) Sarkis

Dbmlsync will only send trigger actions to the consolidated if the SendTriggers externded options is set to ON. The deafult is off. If dbmlsync is sending trigger actions, check the value of this externded option.

When MobiLink determines the rows to download to the remote database, it is likely just executing a SELECT statement on a table, so it doesn't matter at that point whether the value is in the table as a result of a trigger or not.

Reg

permanent link

answered 16 May, 08:59

Reg%20Domaratzki's gravatar image

Reg Domaratzki
5.4k33578
accept rate: 40%

2

I'll bet you actually remember how that works without looking it up every single time, right? ( unlike me :)

(16 May, 11:32) Breck Carter
Replies hidden

Are you meaning me in this comment? I didnt get what you mean!!! Sarkis

(16 May, 17:02) Sarkis

Hi Reg, Yes, on the consolidated side we are using shadow table containing primary key of the table + last_modified, which means that on the cons. even the through trigger coming changes will be included in synchronisation and will be sent to remote.

About the synchronisation from remote side, I am not yet sure, I will test it and write again.

Sarkis

(16 May, 17:05) Sarkis
1

He means Reg.

(16 May, 17:50) Volker Barth
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×295
×60

question asked: 15 May, 09:54

question was seen: 477 times

last updated: 16 May, 17:50