Server Management - Systems Insight Manager
1833187 Members
2911 Online
110051 Solutions
New Discussion

migrating SIM on MSDE to Sql 2005 Standard

 
Andrew Nicholson_1
Occasional Contributor

migrating SIM on MSDE to Sql 2005 Standard

Hello All,
I’m somewhat new to HP SIM 5 so please bear with me...
My question has to do with the details involved in migrating from a MSDE install to platform where SQL 2005 (standard) is the backend.
I've seen the document "Moving HP SIM 5.0 to a new Windows system" which addresses a SQL 2000 backend. This document is found at:
http://h10018.www1.hp.com/wwsolutions/misc/hpsim-helpfiles/hpsim_5_migratingNewSystem.pdf
Not being a SQL DBA and given the dramatic differences between SQL 2000 and SQL 2005 I'm having some problems completing the migration. I need to know if there is an updated version of the above document that is directed at the UI found in SQL 2005? I've tried an initial migration of our MSDE data with mixed results. Having correctly updated documentation on this would be a great help.

PS. I do have a DBA in house and have overcame the confusion in connecting to a DB on SQL 2005 (just point the SIM installer to the Master DB and let it create the SIM DB). My issues are more with the instructions and how they apply to SQL 2005.

Thanks in advance

Andrew