October 10, 2008 at 12:56 am
SqL 2005
Merge Replication
Im stuck in my work because i cant modify the table.
Im assigning a new primary key to one of the columns and this will trigger
an error because of change in schema.
What i want is how can i change this in :
1. script or GUI way and
2. without dropping the current replication setup
(both DB are used in the production)
Thanks
October 12, 2008 at 7:48 pm
anyone?
October 13, 2008 at 6:41 am
i had a similar issue and only way i could do it was to drop the column being replicated from replication, do schema change then reapply it to replication. Not saying this was the best way but it worked for me.....
_________________________________________________________________________________SQLGeordieWeb:- Jarrin ConsultancyBlog:- www.chrisjarrintaylor.co.ukTwitter:- @SQLGeordie
October 20, 2008 at 7:28 am
Hi,
You are wanting to change the PK on the table that is being replicated? AFAIK you will have to remove replication on this table entirely, because the PK is used to perform replication in the first place. The PK is the unqiue idenitifier used to keep your two tables (source and target) in sync.
regards
GermanDBA
Regards,
WilliamD
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply