How to migrate node details only

Is there a way to export/import only the nodes details from one NPM 9.1 DB to another, I don't need historical data..

I am building a new Orion Infrastructure in a different datacenter.

I don't want to backup/copy my 20gb DB. Nor do I want to rediscover the recources and reselect interfaces.

Find more posts tagged with

npm_9.1

migrate

Database

netperfmon

9.1

db_backup

node_details

Hi,

I am not sure this is the smartest/fastest solution but here is how I would do it:

1) Stop the Orion services.

2) Connect to the database. Truncate the statistics tables to only keep your settings.

The tables that end with a _Detail, _Hourly, _Daily contain statistics but no settings.

The Traps, TrapVarbinds, Syslog tables can be truncated too.

Doing so should reduce enough the size of your database

You did not specify if you have any Orion modules installed so I listed only NPM tables.

3) Backup your DB, move it to the new server and restore it.

NPM Settings and statistics tables are in the same filegroup so it is not possible to backup only a specific file such as detailed in the following link: http://msdn.microsoft.com/en-us/library/ms179401.aspx

HTH,

Yann