none
Transaction replication

    Question

  • 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

     

    .

     
    Monday, April 09, 2018 1:29 PM

All replies

  • 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.

    Monday, April 09, 2018 2:15 PM
    Moderator
  • Hi Hilary Can you explain bit more  . In this situation can we use same publisher for both(2016) and 2014  subscribers.

    Many thanks

    Friday, April 13, 2018 1:34 PM
  • 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.

    Friday, April 13, 2018 2:18 PM
    Moderator
  • 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

    Friday, April 27, 2018 9:13 PM