We are deploying a new monitoring subnet and before we move our production monitoring to the new subnet, we want to make that all devices that are reachable today are reachable from our new subnet. I have another license of NPM installed and running on a VM server. I created a test database instead of using our production one and I am trying to figure out an easy way to migrate our node data from the production database to the test database. I don't need all of the statistics. Just the nodes to ensure that SNMP will work.
Or is there a way to export all nodes with IP addresses and do a bulk import?
I am obviously not a SQL guy...any pointers?