none
Transactional Replicate a Subscriber Database RRS feed

  • Question

  • I'm curious if it is possible to publish a database table for transactional replication that is a subscriber for that table.  Basically, I've got Database A that's the source for table T.  Database B is the subscriber.  I now want to duplicate all of database B to a client database C.

    I'm concerned that table T will have problems because it's populated by being a subscriber from database A.

    Thanks in advance,

    Terry

    Tuesday, June 16, 2015 5:03 PM

Answers

  • This is perfectly possible. Check this link https://msdn.microsoft.com/en-us/library/ms152553.aspx

    The link is for sql 2016. but this is possible in all other versions as well.


    Regards, Ashwin Menon My Blog - http:\\sqllearnings.com

    • Marked as answer by TerrySt Tuesday, June 16, 2015 6:18 PM
    Tuesday, June 16, 2015 5:26 PM