Post reply

2 Publishers ---> 1 Subscriber ... is it possible ?

  • October 1, 2007 at 3:33 pm

    #181771

    2 Publishers ---> 1 Subscriber ... is it possible ?

    I wanted to know if i can have 10 tables from Server-A and another 12 tables from Server-B Transactionally replicated into Server-C... What i want here is some tables from Server-A and other tables from Server-B into Server-C.. so that i can do reporting out of Server-C.

    If not replication, please provide me with some suggestions/Advices as what else can be my options here.

    ...Kumar

  • October 1, 2007 at 3:53 pm

    #737924

    Definitely possible. Do the tables overlapp ? If they don't then is pretty easy. If they do you should worry about PK collisions and reinitialization issues.

    Cheers,


    * Noel

  • October 1, 2007 at 4:00 pm

    #737925

    The tables from both the servers are totally independent of each other as they are data from DB's catering to different needs. I thought it would be great to have all the data useful for reporting in one server. What are the other possible ways i can have the data onto a 3'rd server as i have heard friends say transactional replication is not easy as it sounds. Thanks for your reply Noel.

    ...Kumar

  • October 1, 2007 at 4:22 pm

    #737929

    Nothing without study is easy but once you get to practice and get your feet wet with the documentation is easy to handle. In this case you just set up two publications going to the same destination DB and "voila" 🙂 Use BOL the documentation on replication is excellent for the most part. Only certain tricks are not documented but you will be able to do all you need.

    Good luck


    * Noel

  • October 1, 2007 at 10:35 pm

    #738012

    Thanks a lot for your advice Noel.

    ...Kumar

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

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