forums › forums › SQLyog › Using SQLyog › Schema Comparison Tool Showing Target Changes With Identical Tables.
- This topic is empty.
-
AuthorPosts
-
-
August 31, 2011 at 8:42 pm #32605
peterlaursen
ParticipantAs far as I can see the columns order is not identical on source and target. Schema Sync will also consider columns order and sync to identical columns order. Am I right?
If not you will have to provide a 'non-obfuscated' dialog along with CREATE TABLE statement for the table at both ends. If you do not want to do in public here you may create a prviate ticket by mailing to [email protected].
-
September 1, 2011 at 8:33 am #32606
Terry D.
Member'peterlaursen' wrote:As far as I can see the columns order is not identical on source and target. Schema Sync will also consider columns order and sync to identical columns order. Am I right?
If not you will have to provide a 'non-obfuscated' dialog along with CREATE TABLE statement for the table at both ends. If you do not want to do in public here you may create a prviate ticket by mailing to [email protected].
Hi Peter,
Sorry for the obfuscation, it's a matter of policy that we mask this stuff. I compared dumps of the two tables and found that they were indeed in a different order; so the changes listed and the resulting query are in fact correct, it's just that the dialog isn't displaying them in the order they're found.
Does this count as a bug or is it behaving as intended? (I'll send the dumps and screenshot to your support address for comparison)
Terry.
-
September 1, 2011 at 7:20 pm #32607
peterlaursen
ParticipantWe will reply in the private ticket you created!
-
-
AuthorPosts
- You must be logged in to reply to this topic.