[gonzaloleon]

'peterlaursen' wrote:

One additional comment: SJA executes the WHERE clause on the source only and not on the target. If we should deleted on target this would be without considering the WHRE clause. That is why we have disabled DELETE when a WHERE clause is used..

Sure, that's why i post my example for futures developments.

'Jan.S' wrote:

Hi,

Like I mentioned, whenever a where clause is used, we do not delete any data irrespective of if the “delete extra rows in target” is checked or not. However, we are releasing 10.5 GA within a week, which includes a visual data comparison tool which can be used to delete the extra rows. The beta version with this feature has been released. You can take a look at it and download from here.

Regards,

Janani

I'm going to test.

Thanks!

[gonzaloleon]

'Jan.S' wrote:

However, extra rows will not be deleted under any circumstance when a WHERE clause is used.

'shubh' wrote:

Hi,

Quoting from documentation here: http://static.webyog…I_for_MySQL.htm

“If a WHERE clause is specified then it syncs all columns of the table that satisfy the WHERE clause.”

As case specified by you, by giving “id_server = 2” will sync only those rows of the table that have “id_server = 2”. It will not sync any other rows of the table.

We have “Don't delete extra rows in target database” option in Database Sync wizard. Quoting from documentation here: http://static.webyog…SQL_Manager.htm

“The extra rows present in the target database are deleted if you keep the checkbox 'Don't delete extra row(s) in Target database' unchecked.”

Thats right but, take this example:

One Way sync (with delete extra rows on target)

Read on Master -> Write changes to Slave

Where id_server = 2 -> 130 (rows) -> Target: where id_server = 2 -> 134 (rows) -> then delete those extra (4) rows.

This is possible?

[gonzaloleon]

'ashwin' wrote:

Hi,

Please confirm whether you are doing One-way sync or Two-way sync? Because Insert from Target to source happens only in Two-way sync.

Regards,

Ashwin

I'm having the same problem, i make another post.

In my case, im doign one way sync.

Thanks!

[Author]

Posts