none
SQL 2019 Upgrade RRS feed

  • Question

  • Team,

    we have SQL 2016 running on our environment.

    • can you pls share Pros & cons to upgrade sql 2019 environment?
    •  recently SQL 2019 release with CU1, shall we wait for first quarter to fix some bugs in sql 2019?
    • apart from analytics, is this gives sqlengine  Performance compare with sql 2016.
    • in-place upgrade / side-by-side upgrade which one best & safe ( in production).
    • we have SSRS (native) running on production. during in-place upgrade this existing SSRS removed . and we need to install SSRS feature alone & setup SSRS using restore encriptionkey/db backup.
    • & we have Transcational Replication ServerA (pub+distribution) to Subscriber.  So first update Publication then Subscriber is possible?  ( we cannot upgrade subscriber then publisher? )


    • Moved by Tom Phillips Monday, January 13, 2020 1:03 PM Upgrade question
    Monday, January 13, 2020 7:26 AM

All replies

  • Hello,

    >>can you pls share Pros & cons to upgrade sql 2019 environment?
    SQL Server 2019 add more feature, you can refer to Comparation with SQL 2016 vs 2017 vs 2019

    >> recently SQL 2019 release with CU1, shall we wait for first quarter to fix some bugs in sql 2019?
    I think current version can meet most of your demands, you don’t have to wait the next CU if you have to upgrade to SQL 2019. It will not let you down.

    >>apart from analytics, is this gives sqlengine  Performance compare with sql 2016.
    Definitely, SQL 2019 is better than SQL 2016. Here is introduce new function of SQL 2019 

    >>in-place upgrade / side-by-side upgrade which one best & safe ( in production).
    I recommend Side-by-side upgrade. Because In-place upgrade need more downtime and it is difficult to  roll back if we want to. More detail please refer to this Article: https://blog.sqlservercitation.com/2016/12/29/sql-server-upgrade-action-plan/

    >>we have SSRS (native) running on production. during in-place upgrade this existing SSRS removed . and we need to install SSRS feature alone & setup SSRS using restore encriptionkey/db backup.
    Yes, you are right. More detail, you can refer to Upgrade and Migrate Reporting Services

    >>we have Transcational Replication ServerA (pub+distribution) to Subscriber.  So first update Publication then Subscriber is possible?  ( we cannot upgrade subscriber then publisher? )
    It’s ok when you use in-place upgrade. But you have to upgrade Publisher first, then upgrade Subscriber when you use Side-by-side upgrade. For Upgrade replication database, you can refer to Upgrade or patch replicated databases

    Hope it will help.

    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.


    Monday, January 13, 2020 8:39 AM
  • Hello,
    Have you solved the question?
    If you have resolved your issue, please mark the useful reply as answer. This can be beneficial to other community members reading the thread.
    In addition, if you have another questions, please feel free to ask.
    Thanks for your contribution.

    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Thursday, January 16, 2020 5:51 AM
  • Dawn,

    >>we have SSRS (native) running on production. during in-place upgrade this existing SSRS removed . and we need to install SSRS feature alone & setup SSRS using restore encriptionkey/db backup.
    Yes, you are right. More detail, you can refer to Upgrade and Migrate Reporting Services

       this report services not shown in SQL server Configuration Manager.

    >>we have Transcational Replication ServerA (pub+distribution) to Subscriber.  So first update Publication then Subscriber is possible?  ( we cannot upgrade subscriber then publisher? )
    It’s ok when you use in-place upgrade. But you have to upgrade Publisher first, then upgrade Subscriber when you use Side-by-side upgrade. For Upgrade replication database, you can refer to Upgrade or patch replicated databases

    for this in-place upgrade ,  shall i upgrade subscriber then publisher? 

    need to stop Distributor agent? logreader agent @ publisher?  or stop distributor agent alone? ( distributor running in publisher server)

    Saturday, January 25, 2020 5:29 AM
  • Hello,

    Sorry for the delay replying since we just finished Chinese New Year.

       this report services not shown in SQL server Configuration Manager.

    >> Yes, report service will not shown in SQL Server Configuration Manager, you can download Report Server Configuration Manager.

    for this in-place upgrade ,  shall i upgrade subscriber then publisher? 

    >> Yes, you can upgrade subscriber then publisher.

    need to stop Distributor agent? logreader agent @ publisher?  or stop distributor agent alone? ( distributor running in publisher server)

     >>You need to stop distributor agent before upgrade. For Logreader agent at publisher, Allow time for the Log Reader Agent to copy transactions to the distribution database, and then stop the agent

    Hope it will help. Any further question, let me know.


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Thursday, January 30, 2020 8:40 AM
  •  this report services not shown in SQL server Configuration Manager.

    >> Yes, report service will not shown in SQL Server Configuration Manager, you can download Report Server Configuration Manager.


    reporting services installed but , this services not shown in SQL server Configuration Manager

    Friday, February 7, 2020 10:29 AM
  • Hello,

    What do you mean? Of course, reporting services will not show in SQL Server Configuration Manager. I mean you can configure reporting service using Reporting sevices configuration manager. 

    You can see reporting service in windows services as bellow:


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Friday, February 7, 2020 11:54 AM