Data Synchronization Problem

[Vamsidhar]

Hello All:

I am a new member. Just joined today. Glad to have found out about SQLyog. I just started looking at what we can do with SQLyog.

I am really amazed by the kinds of features it provides.

Anyways, I was trying to synchronize (data) two databases (having exactly the same structure). Few tables in the database do not have a primary key. They are kind of configuration tables (you may call them properties which drive the application sort of) and are fixed in structure and data.

The data synchronization tool was able to synchronize the data in all the tables except for those which did not have the primary key.

I checked the log file

No PRIMARY KEY defined in the table '`XYZ`'. was the error.

Is there any workaround for this problem.

Thanks in advance.

Vamsidhar.

[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