Post reply

Alter Table

  • February 12, 2011 at 3:03 am

    #234351

    Hi All,

    If we want to alter a table which is participating in the replication(@publisher or @ subscriber), what is the process need to follow?

    I have one solution..... Drop that article from the replication and alter it, then add it to replication again, will work. but I think it will work it we wont add the coloumns to that article, it will work only if modify the column width or size.

    Can you please suggest the other ways also ?

    Thanks in Advance.

    Thank You.

    Regards,
    Raghavender Chavva

  • February 14, 2011 at 8:27 am

    #1286520

    For transactional replication, You can just add the column in the primary and it will get added in secondary. There are some gotchas of course. One is you cannot alter the PK. Second is adding a column that has identity defined and the third is the column cannot be NOT NULL.

    If it is any of these cases then you will remove the article from publishing and then alter the table. After it is done, you can add it back. This will create a snapshot mind you.

    -Roy

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply