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 ?
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)
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.
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.
SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 150,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process.