-
Re: migrating NPM database from SQL server 2005 to SQL server 2008
rob.hock Oct 22, 2013 5:52 PM (in response to makecrazy)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.
-
Re: migrating NPM database from SQL server 2005 to SQL server 2008
makecrazy Oct 23, 2013 12:06 AM (in response to rob.hock)rob.hock 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 ?
-
Re: migrating NPM database from SQL server 2005 to SQL server 2008
rob.hock Oct 23, 2013 10:40 AM (in response to makecrazy)Negative- there are a host of schema updates that occur between 10 and 10.6
-
-
-
Re: migrating NPM database from SQL server 2005 to SQL server 2008
makecrazy Nov 26, 2013 11:46 PM (in response to makecrazy)-
Re: migrating NPM database from SQL server 2005 to SQL server 2008
RichardLettsNov 27, 2013 9:35 AM (in response to makecrazy)
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.
-