Have you looked over the upgrade guide?
SolarWinds Knowledge Base :: Compatibility of SolarWinds Orion Products for Installation and Upgrade
...although with what you've described, I would think it would be more comparable to an uninstall of your current node and install fresh on your NPM server rather than an actual upgrade, as you suggested in your questions. You can find the NTA install doc here:
2 of 2 people found this helpful
Agreed that you should see the upgrade instructions.
It is no longer needed to have a second instance of Orion on a second server. But, don't go giving that server up just yet!
NTA is now supposed to be set up on a second server, all by its lonely self!
If you take down the second ORion, Assuming that you really are not using it anyway, take all of the software off of it. Unlicense it as well and save the information, (Suggest backing up the complete server first, jsut in case you need to go back.)
On the main server, you will be installing some base programs but NTA will really need to be installed on the SECOND server. All that this does is run the NTA software processes and construct a NEW SWQL database that is NOT SQL. you do NOT need a second SQL license. Please read the upgrade notes at this point. They are pretty good but run through them a couple of times before doing this step.
Now you need to make sure that the SQL server is reachable from the NTA server (to be). You will need to have the UID and PW for the SQL server so that NTA can reference it for Nodes and such. Also, the Orion server (number 1) will need to have rights on the NTA server to write the data to it.
You do NOT need to change any Netflow destinations in your equipment if the Orion server is the current destination. NPM will handle this.
You WILL have to let the NTA server cull all of the records out of the SQL database. It will ask during the installation on the NTA server. Say yes and let it do it right away. It will gather the data and format it for you and then be able to present it to you in a couple of hours, if you have a large installation.
Again, look at the install notes and make sure you are familiar with them. After all of this is done, make sure you can see most of the pages correctly.