Post reply

Adding column/Table in Transactional Replication

  • May 16, 2004 at 8:37 am

    #161485

    Hi

    i implemented transactional replication ,it was working fine but when i added one column in publisher with sp_repaddcolumn it is not replicating ,i used

    sp_repladdcolumn  @source_object =  'sourcename'

        ,  @column = 'rep'

         ,  @typetext =  'char(10) null'

         ,  @force_reinit_subscription =  1

    will it not be replicated in subscribers?,plz also tell how i can replicate the new table if i add in publisher.

    also suggest where can i open replmon.pmc file as it is not opening in performance monitor bcz it demands for .msc file.

    Thanks

  • May 16, 2004 at 11:02 pm

    #506596

    I've never had a problem with sp_repladdcolumn!

    As for adding a new table to the replication process, you will have to add it to the publication and either redo the snapshot so that the subscriber gets the new publication or just create the table on the subscriber so that you don't have to perform the snapshot again!

    Kindest Regards,

  • May 17, 2004 at 12:07 pm

    #506685

    looks like you told it to reinitialize, but didn't tell it to do a new snapshot before hand . . . @force_invalidate_snapshot = 1

    now that the deed is done:

    1. make sure no transactions are pending and clear any conflicts.
    2. stop subscriber(s) synchronization.
    3. run another snapshot.
    4. reinitialize the subscription(s).

  • May 17, 2004 at 9:36 pm

    #506727

    Hi

    Thanks for your info,but @force_invalidate_snapshot default is 1 so is it necessary to give 1 explicitly .

    Thanks

Viewing 4 posts - 1 through 3 (of 3 total)

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