[Shadow]

W98 SE has scheduler as well…

[Shadow]

As long as SQLyog Max is not released you could use DBDesigner4 as a visual query builder for MySql. Personally I use SQLyog for administering MySql dbs and DBDesigner for modelling and developing dbs. Hopefully SQLyog Max will include most of the features of both line!

[Shadow]

It seems that MySql can't find cdrmsg table in the source db or can't create it in the target db (permissions issue).

[Shadow]

You may set which fields of a given table should be synced in the Columns field. Table and column aliases cannot be set via GUI, although you may try to manipulate the xml file directly… I believe, however, that the options provided by sja are sufficent for all synchronization tasks!

[Shadow]

Sure, but there was no indication of the SQLyog version being used…

[Shadow]

Quote:

It will create sja.log in the installation directory of SQLyog.

Or in the directory where you saved the xml file describing the sync…

[Shadow]

I use them both without any problem! I would be greatly surprised if any one of them interfered with the other 😀

[Shadow]

I'm sorry Ritesh, but SQLyog always creates the sja.log file in the last used folder for me! I just made SQLyog to place one in MS's Visual Studio's root folder… It's got nothing to do with the location of sja.exe!

[Shadow]

SQLyog does not create the sja.log file in the install directory. The sja.log is created in the folder that was last used for saving anything (jobs, data exports…) to HD or to load anything from HD. If that folder is the install folder (default), then SQLyog creates it there, otherwise no.

[Shadow]

I meant bad news, not new…

[Shadow]

Well, Hughes, bad new for you, the data sync tool works perfectly for me… Even if only a few records have been changed in the source db.

Ritesh, could you enlarge the textbox that displays the result of the synchronization session?

[Shadow]

The syncronization of the dbs can be done with SQLyog, but you'll have to write a script that extracts each order as a separate text file. You could download MyODBC from MySql's site and write a VBScript that does the job. The problem is that windows scheduler does not have the option of executing a file after another job was finished…

[Shadow]

There is definitely a bug because the “Reasons…” button just SEEMS to have disappeared, if I click the area where it should be displayed, then the button suddently appears!

[Shadow]

Hmmm… If I execute a select for update on a statement which resultset cannot be edited, then pressing the “Refresh” button causes the “Reasons…” button to disappear. Is this behaviour by design or just a little bug?

[Shadow]

In such cases SQLyog explains why an update cannot be done. Just click on the “Reasons…” button.

[Author]

Posts