Migrate NTA to new SQL server - no need for historical data

Hello,

Pretty sure easy as running config wizard, point at new SQL Server for NTA, create DB, done! Still keeping Orion on existing DB, just trying to separate for better permanence.

Let me know there is another step that I may be missing. Assuming worst case I can always run wizard to return back to old server.

Thanks

Zak

Find more posts tagged with

nta_db

nta_db_migration

nta storage

Accepted answers

neomatrix1217

Then you would be correct assuming you want to start fresh run the config wizard first step is the Orion DB after the website configuration the wizard will prompt for the NTA DB you will need a SQL account to create a new DB on that SQL server that you are moving to and create a new SolarWinds SQL account and NTA DB name and then just let the wizard complete.

Success Center - his article provides information on changing the deployment type of the NTA Flow Storage database running on SQL server

All comments

designerfx

Are you talking about migrating 4.2.x, or is this something newer? If it's something newer it's just another SQL DB.

zkahl

Just moving to another DB. Same NTA 4.4.0 version.

neomatrix1217

Success Center - his article provides information on changing the deployment type of the NTA Flow Storage database running on SQL server

zkahl

Thanks all for confirming. All went well yesterday as I was hoping. Been a while so wasn't sure if there was something else changes with 12.3/14.4 NTA,

Thanks!