Moving VCEM Database

[Tusc]

Hey all.. my SIM\VCEM DB (6.3) is currently running on a sharded SQL server. I'd lik to move the database to a local SQL instance and them upgrade everything to 6.3.1. I wouldn't be switching to a new CMS.. just moving the database. Is the an SOP for this?

[Hongjun Ma]

VCEM uses the HP SIM database.

I'm not a DB guy but this link provides you some good discussion around the topic

 http://h30499.www3.hp.com/t5/ITRC-HP-Systems-Insight-Manager/Migrating-HP-SIM-Database-into-new-SQL-Server/td-p/4759571

there are two white papers referred

“How to move an HP Systems Insight Manager SQL 2005 SP3 database from local to remote server White Paper”

http://h20000.www2.hp.com/bc/docs/support/SupportManual/c02047132/c02047132.pdf

"Data Migration of an Existing Microsoft Windows CMS to a new Insight Software 6.2 System White Paper": http://h20000.www2.hp.com/bc/docs/support/SupportManual/c02537453/c02537453.pdf

hope it helps