Post reply

Shared data

  • November 6, 2013 at 7:03 am

    #278911

    So I have a scenario where two seperate entities of our business need access to data across a few tables. We have:

    server1 - central repository of all data

    server2- subcriber to replication on server 1 which pulls certain tables

    server3- requires a selection of the data from what is pulled onto server 2

    My question is, can tables which are subscribers also be a publisher? OR would I be better off setting up linked servers from server 2 - 3 and having views set up on server 3 instead?

  • November 6, 2013 at 7:22 am

    #1664462

    Can you make Server3 a subscriber too? If you don't want the entire publication you could subscribe to just the articles that you need.

    I have not tried to make a subscriber a publisher too, but that would be an interesting experiment.


    Microsoft Certified Master - SQL Server 2008
    Follow me on twitter: @keith_tate

    Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • November 6, 2013 at 8:11 am

    #1664479

    ah I wasn't aware of row level filters or that you could put these one of the subscribers and not the other.

    Answered my question 🙂 thanks

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

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