Thread: Changing datatype in a table used for replication ?

Changing datatype in a table used for merge replication ?

I'm trying to change the data type on a column in a table that is used for a merge-replication with another (identical) DB.

I get this error:
Cannot alter the table '[Tablename]' because it is being published for replication.

I've tried to remove that specific table from the publication (Publication properties -> Articles tab) so I can change the data type and then put the table back into the publication, but I can't (probably because it's a MERGE rep.)

Any ideas ?

/CN

i am afraid you have to delete the subscription and probably the publication as well. this means creating a new snapshot (after the update) and running the snapshot agent. If this scenario is the only way you have to sync both databases, set them in dbo use only, apply any changes and set up the replication again, don't forget to reset dbo use only. (use scripts that you can generate for setting up replication before you delete the subscription and/or publication).

------------
Carl Nilsson at 2/28/2002 2:59:25 AM

Changing datatype in a table used for merge replication ?

I'm trying to change the data type on a column in a table that is used for a merge-replication with another (identical) DB.

I get this error:
Cannot alter the table '[Tablename]' because it is being published for replication.

I've tried to remove that specific table from the publication (Publication properties -> Articles tab) so I can change the data type and then put the table back into the publication, but I can't (probably because it's a MERGE rep.)

Any ideas ?

/CN