Sync_script Editing

[sdozono]

I'm using SQLyog Enterprise v4.06.

Thank you for the wonderful tool.

I tried to edit Column parameters for Sync_table by using,

---

MENU-> Powertools -> Database Synchronization Wizard-> Edit a saved Synchronization Session -> Select table(s) that you want to synchronize -> Columns.

---

(1)

Even though there were some specified columns in advance, when I double-click the Table Columns, it appears with all Table-Columns checked. (including [ALL]…)

Is this a designed behavior?

(2)

It seems that we can not use “Move Down” button…

Thank for your help in advance.

[sdozono]

As just an information, I'm using your SQLyog on Japanese Windows XP SP1.

So far, I can not see Japanese Kanji(Chinese) Characters through SQLyog, but Synchronization is going well.

[peterlaursen]

1) It seems that the column selection only works as it should if you specify a WHERE-clause. It's a BUG (and actually a bad one I think!) Check if your XML-file says “” even if you specify columns.

2) I can't use “Move Down” either. Actually I don't understand why these buttons are there ..

3) Sqlyog ver 4.1 should be relased in a little less than 2 months (I think). That should fix all character-set related issues, and provide interface for localization of the GUI.

[peterlaursen]

there seems to be a porbelm with escape characters at this forum!

Check if Check if your XML-file says (quoatation)(end-of-quotation) even if you specify columns!

[peterlaursen]

there still seems to be a problem with escape characters at this forum! 😮

Check if Check if your XML-file says (quotation)(bracket)columns all=(inner-quoatation)yes(end-of-inner-quotation) /(end-of-bracket)(end-of-quotation) even if you specify columns!

[sdozono]

Thanx for the useful information! 🙂

And I found another bug.

If you edit the “columns checkboxes” in an exsiting sync_scripts, SQLyog 4.06 will add a back quote characters `(JIS CODE 60) again.

So, the script will be,

`id` -> “id“

Then, it will NOT make SJA synchronize properly.

So, what I did was….

1) Erased unnecessary back quote characters.

2) Adding WHERE-clauses for all the tables that need column specifications.

Then, it started synchronizing successfully!

[Author]

Posts