Transaction replication


  • Hi We have Transaction replication has configured from 2008 R3 to 2014 (pull subscriptions) . Technically working fine. Now I need to configure other replication from  same prod DB on 2008R3 to 2016 SP1 CU7. Previous replication (2018R3 to 2014)  is keep remain as it is.I understand technically this is possible but Microsoft support wise de supported. That is fine  .

    What is best way to configure

    1.  2018R3 to 2016 R1  ( two publishers create on same server(2008R3 ) replicate to two different versions(2014 and 2016R1) subscribers

    2. 2014(replicated DB) to 2016 R1

    Many thanks



    Montag, 9. April 2018 13:29

Alle Antworten

  • Script out one of the pull subscriptions on the SQL 2014 server.

    Edit it for the new SQL 2016 subscriber.

    Run it on the SQL 2016 subscriber and the SQL 2008 R2 subscriber.

    • Als Antwort vorgeschlagen Hannah Yu Mittwoch, 11. April 2018 07:45
    Montag, 9. April 2018 14:15
  • Hi Hilary Can you explain bit more  . In this situation can we use same publisher for both(2016) and 2014  subscribers.

    Many thanks

    Freitag, 13. April 2018 13:34
  • You should be able to.

    To configure the pull subscription for the SQL 2016 server, go to the SQL 2014 pull subscriber. Drill down on the replication folder, expand the local subscriptions folder. Right click on the subscription and select Generate Scripts.

    You will need to edit the generated scripts for your subscriber.

    Freitag, 13. April 2018 14:18
  • Hi Hilary

    Many thanks for the reply and valuable input. Can you please more clarify. My plan is to configure subscriber 2016sp1(pull subscriber)  and publisher 2008 R2 

    in what stage we should change the script.

    Many thanks

    Freitag, 27. April 2018 21:13