[wessel]

Hi all,

I have a similar issue when importing from a view created for me in Oracle. I have set up a import to run every 1 hour and import all from the view with the following where clause:

TEST_DATE > SYSDATE-60/1440

The problem is, this import is totally dependent on time and if for some reason it will find a duplicate, it will import the duplicate. I have tried all 3 different options in the wizard at the advanced tab:

o Update with source details

o Keep target data

o Abort

No matter which option I select, I still get duplicates.

Unfortunately there is no primary key defined as I am importing from a view, but I would still think SQLyog can check for duplicated and follow one of the 3 options above.

Is this a bug in SQLyog or am I doing something wrong?

Thanks in advance for any help, this is my first post on this forum.

Wessel

[Author]

Posts