topic SIM 5.2, change SQL Express to SQL 2005 Standart in Server Management - Systems Insight Manager

SIM 5.2, change SQL Express to SQL 2005 Standart

Juanjo_10 — Thu, 22 May 2008 09:12:20 GMT

Hi to all.

I have a installation of HP SIM 5.2 with SQL 2005 express. I want to change the database to an SQL 2005 Standart with other databases.

Are ther some documentation?
any suggestions?

Thanks a lot.
Best Regards

Re: SIM 5.2, change SQL Express to SQL 2005 Standart

Ervinck Kevin — Thu, 22 May 2008 10:19:52 GMT

1) Stop HPSIM service
2) Detach the HPSIM database in SQL Mangement Studio.
3) Copy the database to the new SqL 2005 Standard server.
4) Create the HPSIM database user on the new SQL 2005 standard.
5) Attach the HPSIM database
6) Compare the security of both HP SIM users.
7) Start HPSIM

More information about the database properties is inside the file database.props

Re: SIM 5.2, change SQL Express to SQL 2005 Standart

Change_happens — Fri, 23 May 2008 03:24:36 GMT

After stoping SIM service if you upgrade to SQL Server 2005 it automatically takes care of migrating data. you need to select the instance that case.
see below may help:
http://www.toddklindt.com/blog/Lists/Posts/Post.aspx?ID=55