Synchronizing Indexes using SJA

[vishalp]

Hi

I have a 'book' table. (Id as primary key, title, price). I now synchronize this table with same table in other database.

I now create index on book table as –

create index b_ind on book(title);

Now when I try to synchronize, it gives me error – PRIMARY KEY definition mismatch for 'title' column in '`book`' table

In SQLyog, extra indexes are copied to the destination database. Does sja provides similar facility? If yes, how to go about it?

Thanks in advance.

Vishal

[Ritesh]

SJA only syncs data. For structure synchronization, you have to use SQLyog's -> Structure Sync Tool.

SJA will fail if the table structure in both the servers are not same.

[Author]

Posts