1 Reply Latest reply on Jul 18, 2016 6:55 AM by r-x

    Upgrading from NPM 11.0.1 and SQL 2005 SP4 to SQL 2014


      Hi all,

      I want to upgrade a system from NPM 11.0.1 to 11.5.3 and SAM from 6.0.2 to 6.2.3

      The upgrade advisor at https://customerportal.solarwinds.com/support/product-upgrade-advisor#/#result-start2 says to upgrade SQL first and lists versions up to 2012 SP1 then upgrade SAM to 6.1.1, NPM to 11.5.3 and SAM again to 6.2.3. It has a box for what version of SQL you are coming from but not which version you're going to. The only newer SQL server currently configured here is 2014.


      I was under the impression I couldn't migrate directly from SQL Server 2005 SP4 to 2014 in one go (perhaps due to SAM SQL support?) https://support.solarwinds.com/Success_Center/Network_Performance_Monitor_%28NPM%29/Windows_Server_2012_and_SQL_Server_2012_and_2014_Support?CMPSource=THW&CMP=REFDOM


      If I understand that correctly is there any issue with me migrating in a 2 step move via say a temporary 2012 Express VM? http://www.solarwinds.com/documentation/en/flarehelp/orionplatform/default.htm#cshid=orioncoreagoriondatabaseserverrequirements.htm states SolarWinds supports Express/Std/Enterprise of various SQL versions including 2014.


      I have had a look at http://www.solarwinds.com/documentation/orion/docs/OrionServerMigration.pdf?CMPSource=THW&CMP=REFDOM for DB migration steps.

      I also saw a similar thread re: 11.0.1 and moving from SQL Server 2005 to 2014  but it's unanswered.


      Thanks for any clarifications/extra info you can provide.

        • Re: Upgrading from NPM 11.0.1 and SQL 2005 SP4 to SQL 2014

          I'm surprised to see 0 responses here but if it helps anyone else later I did this upgrade in 2 database steps via an interim SQL 2012 box just for this purpose and decommissioned it once the DB was on SQL 2014 and the Solarwinds sofware pieces upgraded. Hopefully my next query gets more feedback!

          1 of 1 people found this helpful