changing a primary key in a replicated table

Hi

We have a merge publication - I want to change the primary key for one of the tables (add another column to the primary key)

How do I do it ?

Currently there is no data in the table - which I guess might help..

thanks
Bruce

you can try to run the snapshot agent after change the PK to generate the latest snapshot and reinitialize the subsciption.

I'm not sure if it will work.

Cheers,

Justin

|||

After some testing I worked out that we need to:

a) remove it from the publication

b) recreate snapshot

c) change the primary key at our end

d) change the primary key at their end

e) add it back into the publication

f) recreate snapshot