Post reply

Adding new table to existing publisher

  • April 22, 2005 at 12:01 pm

    #85952

    Greetings,

        I inherited a snapshot replication (32 databases). I added a new table to the publisher db for testing successful replication. My new table is not being replicated to the subscribers. What do I need to do to replicate the new table?

    Thank you

    Randy

  • April 25, 2005 at 8:00 am

    This was removed by the editor as SPAM

  • April 26, 2005 at 12:01 pm

    #554983

    First, you need to add the new article (the new table) to the publication. Then you will need to reinitialize the subscriptions to the publisher.

  • April 26, 2005 at 12:34 pm

    #554995

    I tried reinitializing the subscription this morning but the new table was not replicated.

    What does this do?

    1.) right click on table

    2.) all tasks

    3.) create new publication

  • April 26, 2005 at 1:05 pm

    #554999

    You said that you added a new table to the published database, but did you actually update the publication and add the table to it? Until you do this, the table will not be distributed to your subscribers.

    In SQLEM, right click on the publication, choose properties, click the Articles tab, and make sure that the new table is checked off in the list of published articles.

    After adding the table to the list of published articles, then reinitialize the subscriptions. After marking the subscriptions for reinitialization, you are going to have to kick off the snapshot agent to generate the new snapshot that includes your additional table.

  • April 26, 2005 at 1:24 pm

    #555003

    Worked great!

    Thank you

    Randy

Viewing 6 posts - 1 through 5 (of 5 total)

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