Removing an articel (table)

  • How to remove an artice (table) from replication ?

     

    thanks n regards,

    Skv

     


    subban

  • You'd should just be able to "un-click" a table to remove it from replication, but you can't.

    What I do is:

    1) Right click on the publication that you want to remove the table from.

    2) Generate DELETE script.

    3) Paste into Query Analyzer

    4) Find and run the sp_dropsubscription and sp_droparticle commands for the table you want to run.

    5) All done.

     

    This technique, in conjunction with the CREATE script can be used if the schema of a replicated table needs to be changed.

    You generate & SAVE both the DELETE & CREATE scripts. Remove it from replication, change the table, then add it back in with the relevant portion of the create script.

  • ok, thankz.

    Do i have to do anything at subscriber side ?

    pls help

     

    skv


    subban

  • Hi Subban!

    Some days after I implemented my replication, i needed to remove some tables of the publcation.

    IS this your case?

    I use Enterprise Manager and I had to delete my publication and create one new, because after publication is created we can't remove a table (article).

    But be carefully, because you get an error if you don't delete this articles in the server subscriber!!

    I hope this helps

    Xau, Claudia


    Regards,

    Cláudia Rego

    www.footballbesttips.com

  • No, I'm pretty sure you can leave the subscriber as is.  I just did a test and everything worked fine. I removed 2 tables from a publication, deleted them from the subscriber, then let the jobs run, and the remaining table got updated at the subscriber with no problem.

    You might want to manually delete the table(s) from the subscriber if it's no longer needed.

     

    Claudia, try my suggestion next time, I think you'll find it's easier

     

  • You CAN do it from EM, you just have to remove the all subscriptions first, like the script does.  I've done this a few times before, also added tables.  But after dropping the table you need to re-add the subscription, and rebuild the snapshot.

    Whichever way you do it, it leaves the subscriber's tables there.  You can delete them if you like.

    Dylan

    Dylan Peters
    SQL Server DBA

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

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