forums › forums › SQLyog › Using SQLyog › Data Synchronization Wizard Fails
Tagged: Synchronisation Wizard Error
- This topic is empty.
-
AuthorPosts
-
-
March 30, 2015 at 9:26 am #35267
Abhishek Kumar Pandey
MemberAre there any locks on the table you mentioned in source or destination?
-
March 30, 2015 at 11:22 pm #35268
maxhugen
ParticipantNot that I’m aware of. No-one was logged in, and I tried it a number of times.
-
March 31, 2015 at 9:17 am #35269
peterlaursen
ParticipantAs this is reproducible one server and not another – and with same data – it must have something to do with a specific server environment/configuration. To find out what it exactly is causing tis without access to the server, would for us be like searching a needle in a haystack with our eyes blindfolded.
Was it possble that we could have temporary read access to the data on this server (on another ‘faked’ dataset where it is reproducible)? If so please send credentials and details to [email protected]. If your client will not allow us to access the real data, then please try
1) duplicate the problematic table (dump this table, and import to another database, or just to a new differently named table, for instance)
2) verify if problem persists with the new duplicated table s well.
3) (if required) delete most ofte data in this table (say except for 50 or 100 rows), ‘fake’ sensitive data in remaining rows, again verify that problem persists.
4) provide us access to the duplicated table.
-
March 31, 2015 at 11:50 pm #35270
maxhugen
ParticipantI’m checking with the client re access, will advise.
-
April 10, 2015 at 2:21 am #35271
maxhugen
ParticipantCouldn’t get permission to provide read access to the db. It’s for a $billion hospital construction project, with a lot of confidential contractor info.
However, I was finally able to sync the table with the issue, and now the SQLyog Job Agent is running AOK again.
-
April 10, 2015 at 5:19 am #35272
Abhishek Kumar Pandey
MemberJust for my curiosity, what was the issue?
-
April 10, 2015 at 11:01 pm #35273
maxhugen
ParticipantUnfortunately, I was not able to determine the cause of the issue. 🙁
-
-
AuthorPosts
- You must be logged in to reply to this topic.