Moving DB from SQL 2005 to 2008

jonchill

Currently our NCM DB resides on a SQL 2005 DB, I'm currently building a new server which is going to be Windows 2008 x64 and SQL 2008 x64.

What I want to do is pickup the 2005 DB and attach it to 2008 is it as simple as that or is there a lenghty process I need to do to migrate to 2008?

Thanks

 

Jon

njoylif

my experience has been it is that simple.
The only gotcha I've run across is - ensure you have the SolarWindsNPM [or your custom] user created and permissions set prior to.
If you migrate the IP address/DNS name (depending on which you use), you should be golden.

I just detached the db(s), copied to new system, attached and changed any directories/names as necessary and viola.  This also ensures you have an in-tact DB in 2005 if you need to roll back or deal with any issues.

hope it goes smoothly.