Post reply

Sharing a publication

  • September 6, 2005 at 3:31 am

    #91019

    Hi

    I am setting up transactional replication for a database.  I want to replicate the whole database to one place, and just one table of it to another.  I have already set up the publication to replicate the whole database, and now I would like to use this publication to replicate just one table of it.  However, when I set up a new subscription, all I can do is subscribe to the whole thing.  Is there anyway to "re-use" the existing publication - I'm sure this would improve performance?

    Thanks

    John

  • September 6, 2005 at 4:27 am

    #587713

    use sp_addsubscription and in the @article parameter use the article name.

    --

    Hilary Cotter

    Looking for a SQL Server replication book?

    http://www.nwsu.com/0974973602.html

    Looking for a FAQ on Indexing Services/SQL FTS

    http://www.indexserverfaq.com

  • September 6, 2005 at 4:57 am

    #587720

    Hilary

    Thanks, but my publication uses concurrent snapshot processing, and when I try to subscribe to just one article, I get a message saying I have to specify all articles.  Is there a way round this?  Perhaps I can modify my publication somehow?

    Thanks

    John

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

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