|
Replies:
0
-
Pages:
1
|
Threads:
[
Previous
|
Next
]
|
|
Posts:
1
Registered:
1/10/11
|
|
|
|
Cannot compare two DB - Devart.Data.MySql.MySqlException
Posted:
Jan 10, 2011 7:07 AM
|
|
|
|
|
I tried to compare two DBs (5.0 vs 5.5) using TOAD 5.0.
It failed with the following error:
1/10/2011 8:09:46 AM; Error; Table Reading error.
1/10/2011 8:09:46 AM; Error; ----------------------------------------------- Exception -----------------------------------------------
1/10/2011 8:09:46 AM; Error; Devart.Data.MySql.MySqlException
1/10/2011 8:09:46 AM; Error; You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'key as binary)' at line 1
1/10/2011 8:09:46 AM; Error; StackTrace : at Devart.Data.MySql.bk.r()
at Devart.Data.MySql.bk.d()
at Devart.Data.MySql.v.a(ah[]& A_0, Int32& A_1)
at Devart.Data.MySql.v.a(Byte[] A_0, Int32 A_1, Boolean A_2)
at Devart.Data.MySql.a2.e()
at Devart.Data.MySql.a2.o()
at Devart.Data.MySql.MySqlCommand.InternalExecute(CommandBehavior behavior, IDisposable stmt, Int32 startRecord, Int32 maxRecords)
at Devart.Common.DbCommandBase.ExecuteDbDataReader(CommandBehavior behavior)
at System.Data.Common.DbCommand.ExecuteReader()
at Quest.DataCompare.PL.TADataDifference.OpenFirstQuery()
Full log is attached.
Any ideas?
TIA,
Vitaly
|
|
|
|
Legend
|
|
Guru: 2001
+
pts
|
|
Expert: 751
- 2000
pts
|
|
Enthusiast: 31
- 750
pts
|
|
Novice: 0
- 30
pts
|
|
Moderators
|
|
Helpful answer
(5 pts)
|
|
Answered
(10 pts)
|
|
