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.