Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials

migrating NPM database from SQL server 2005 to SQL server 2008

hi can any 1 share the procedure to migrate NPM database from SQL server 2005 to SQL server 2008

is SQL 2005 DB is compatible with SQL 2008

As we are running NPM 10.0 and now we are moving to NPM 10.6 as per procedure we have to do up-gradation as per following steps to make DB work

Upgrade NPM to NPM 10.2

- Upgrade NPM to NPM 10.4

- Upgrade NPM to 10.6

is there any way to build a test server on which i can perform above up-gradation process so that i can have NPM 10.6 DB for my new Server ?

Find more posts tagged with

Accepted answers

All comments

rob.hock

Have you perchance checked out our migration guide? http://www.solarwinds.com/documentation/orion/docs/OrionServerMigration.pdf

SQL 2008 also comes with a copy DB wizard to walk through that process. If you were looking to to test the procedure- previous versions are available in your customer portal or via support.

makecrazy

thanks for urs reply.

is there any way to use NPM 10.0 DB for NPM 10.6 DB because its lengthy process to upgrade NPM 10.0 to NPM 10.6 ?

rob.hock

Negative- there are a host of schema updates that occur between 10 and 10.6

makecrazy

when ever i try to restore NPM DB of 10.0 to 10.1.3 on SQL server Management Studio it always show following error , kindly help me out to use NPM 10.0 DB on NPM 10.1.3

on NPM 10.0 iam using SQL server 2005

for NPM 10.1.3 i want to use NPM 10.0 DB on my new SQL server machine ( SQL server 2008)

RichardLetts

What steps did you perform to get to this place?

If you installed 10.1.3 on your new database and then tried to restore over it then I would expect it to fail because the schema do not match. The Application upgrade/install process includes steps that migrate the contents of your database to the new schema

the PDF document Rob linked to above is quite complete.