• I would definitely recommend installing to a new server.

    It is safest to assume that any new SQL version has changes to the RS Catalog database, so do not plan on restoring a backup of your old RS DBs to your new server (also don't to a detatch/attach of the old DB). Instead, get hold of RSScripter from sqldbatips and use this to migrate all your RS objects to the new database.

    When you have migrated all your objects, test that everything works as expected. You can then swap your new server into live and take the old server out of live use.

    Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.

    When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara