help - add table & data in replication

  • Hi,

    In SQL SERVER 2008 R2 Transactional Replication, how to add new table & data into existing subscription.

    already Transactional publication configured in primary database server, after that new table was created on same database. this table how to move subscription database server?

    I tried as below command, but it is not hope.

    EXEC sp_addsubscription

    @publication = 'TransRep_Publication',

    @article = 'dbo.newtablename',

    @subscriber = 'servername',

    @destination_db = 'TransRep',

    @reserved='Internal'

    Msg 20027, Level 11, State 1, Procedure sp_MSrepl_addsubscription_article, Line 123

    The article 'dbo.testdata' does not exist.

    thanks

    ananda

  • Add the new table as an aritcle to the publication and generate snap shot.

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

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