Change PK during replication

[quisar]

Hi!!

Can we change primary key of tables when used in replication? The problem I have is,
There is a table with 2 primary keys, I want to add one more column as pk to this. I'm not able to do it since it is an allow null. I tried changing the null to not null after updating that column's values. but it doesnt work, it gives error. How can I solve this?. Can i remove all pks during replication for that table and handle all validations in front end itself?

Thanks,

Quisar

 

[MeanGreen]

Can you just set up a UNIQUE Index on the three columns to maintain uniqueness? Now sure about the replication part. You could drop the key and recreate, but then you would have to reproduce the replicant I believe.

Hope this helps.