Data Synchronization Problem

[peterlaursen]

no there is no workaround! Sqlyog identifies the records by the PK. So wuthout a PK in the tabel you can't use Sqlyog.

If you're in control of the DB you could add an “autoincrement” integer/long type row to the table and make this one the PK.

[Vamsidhar]

Thanks for your reply.

Do you think copying the table data (feature in SQLyog) would do the trick for me.

I still did not get a chance to try this. I will try it out and let you know.

Othewise I will have to add a PK to the table.

Thanks again.

Vamsidhar

[Ritesh]

Yes but you have to do it separately using the SQLyog GUI. Copying database is not supported in SQLyog Job Agent (engine that performs the synchronization).

We plan to add a feature in one of future releases of SJA where it will automatically drop all data in the target table if there are no PRIMARY KEYs defined. It will then do a complete insert from source to target.

[Vamsidhar]

Thanks for the reply Ritesh.

I will probably use some other method to copy data between tables which do not have PK.

Thanks again.

Vamsidhar

[Author]

Posts