SIM 5.2, change SQL Express to SQL 2005 Standart

[Juanjo_10]

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

[Ervinck Kevin]

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

[Change_happens]

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