Adding article to the existing column

  • G.R.Prithiviraj Kulasingham

    SSCarpal Tunnel

    Points: 4104

    Hi All,

    I am having a server where replication is set up between 2 differnt databases. It is currently running.  I want to add a couple of tables to the replication. I tried using sp_addArticle, but after executing it, in the properties of the publication it shows the new tables, but at the database level the tables are missing.

    I tried with sp_addsubscription but I am getting strange error:

    Server: Msg 14100, Level 16, State 1, Procedure sp_addsubscription, Line 240

    Specify all articles when subscribing to a publication using concurrent snapshot processing.

    What can I do to publish the tables into the target database?

    Thanks in advance.

    Cheers,
    Prithiviraj Kulasingham

    http://preethiviraj.blogspot.com/

  • This was removed by the editor as SPAM

  • cynosure772003

    SSC Rookie

    Points: 36

    Prithvi - First you need to drop the existing subscription.

    Then add the article

    Then add the subscription.

    This will work.


    cynosure

  • G.R.Prithiviraj Kulasingham

    SSCarpal Tunnel

    Points: 4104

    Hi,

    Thank you for oyur reply. 

    The existing publication contains some vary large tables,  (millions of records) so if I drop and re-create the subscription, will I have a new snapshot that will re-populate all the tables once again?

     

     

    Cheers,
    Prithiviraj Kulasingham

    http://preethiviraj.blogspot.com/

  • Scott Arendt

    SSCertifiable

    Points: 7887

    You could create a new publication that contains only the new tables as articles.  That would get you around have to deal with the large tables in a new snapshot.

    I would probably drop the subscription, add the new articles and create a snapshot.   Then, in order to get around replicating millions of records, I would backup the published database and restore it on the subscriber.  When you establish the new subscription, make sure that you do not apply the snapshot.  Replication will then only those records that were added/deleted/updated from the time of the backup until the time of the subscription being applied.

    Regards,

    Scott

     

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

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