[kheine]

Thanks for your help.  😀

 

In the SQLyog FAQ there is this hint:

 

‘When using Floating Point datatypes there should always be a PK based on non-floating column(s) and the PK-column(s) should be included in every SELECT generating a result set used for updating the table.’

 

Taking the index-field into my SELECT, the incremental transfer works fine.

 

Your SQLyog: an excellent tool !

 

Best regards

K.Heine

[kheine]

With the actual odbc-driver there is no error message.

Thanks

[kheine]

Mysql-ODBC Version: 5.01.00.00

[kheine]

[attachment=1911:migration_testheine.xml]The error message also appears with Mysql 5.5.32.

But only with specific jobs like the one I send you and which transfers

data from mysql to mysql-databases.

No error appears, when i transfer from ms-sqlserver to mysql ?!

[kheine]

^{1. MySQL-Server 5.5.13, OS: Windows XP}

^{2. it is always reproducible}

^{3. All data are imported as they should}

^{Last week we were on sqlyog version 10.50 and no error was generated.}

[Author]

Posts