Source Target Conflict – On_date

[tjmcd]

I'm trying to sync 3 MYSQL DBs, one hosted the other two on remote tablet pc's.

I have succeeded in implementing the following where clause,

Code:

WHERE `date_modified` >= SUBDATE(CURRENT_DATE, INTERVAL 3 DAY)

however what I need is something more like

Code:

WHERE source.date_modified > target.date_modfied

Is it yet possible to taylor the Syncornization to update records on basis of most recent Modified Date?

[peterlaursen]

Did you ever read this article:

http://webyog.com/en/whitepapers/Using_SQL…L_Databases.pdf

you will find that actually I too at that time requested a feature like

Quote:

WHERE source.blabla OPERATOR target.blabla

to be supported.

but the server does not understand 'soruce' and 'target'. SQLyog/SJA does not parse the WHERE clause. it is just sent to the server

The article also has a example of how you CAN use timestamps, however. And a 'trick' to use a server constant with the Primary Key.

You will find a few more Forums posts recently about similar issues. Actually we are discussing internally how to improve the usablilty of the DATA SYNC tool. We will udate this:

http://webyog.com/faq/33_20_en.html

when 5.2 FINAL is releases

[Author]

Posts