- Community Home
- >
- Servers and Operating Systems
- >
- HPE ProLiant
- >
- Server Management - Systems Insight Manager
- >
- Migrating HP SIM Database into new SQL Server
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-01-2011 05:12 AM
тАО03-01-2011 05:12 AM
I'd like to know if it is possible to migrate the HP SIM SQL Server database instance from one server into another one since my current DB server hardware must be upgraded ?
is there any simple way or i can just turn off all SIM service and then migrate my SQL Server 2008 database manually to the new server and then turn it on again ?
Any idea would be greatly appreciated.
Thanks
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-01-2011 03:55 PM
тАО03-01-2011 03:55 PM
Solutionhttp://h20000.www2.hp.com/bc/docs/support/SupportManual/c02047132/c02047132.pdf
Found from http://hp.com/go/sim -> Documentation Library -> How to use
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-01-2011 03:57 PM
тАО03-01-2011 03:57 PM
Re: Migrating HP SIM Database into new SQL Server
I hope that this guide applies to 2008 as well.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-08-2011 08:05 PM
тАО03-08-2011 08:05 PM
Re: Migrating HP SIM Database into new SQL Server
"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
Issues that I had to overcome:
1. SIM 6.0 and 6.2 database tables are different so you can't just use SQL tools.
2. A requirement to use the hp mximport utility is that c:\temp must exist and it doesn't by default on Windows 2008 R2. This isn't in the SIM manual DB migration requirements but it is mentioned in the white paper.
3. If Remote Support is installed on the existing SIM, until it is installed on the new server, all the collections on the new server will appear to be empty.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-08-2011 08:13 PM
тАО03-08-2011 08:13 PM
Re: Migrating HP SIM Database into new SQL Server
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-03-2011 02:15 AM
тАО06-03-2011 02:15 AM
Re: Migrating HP SIM Database into new SQL Server
1) go to C:\program files\HP\Systems Insight\Manager\config
2) edit database.admin
3) change hp.Database.hostName=
4) change hp.Database.instance=
5) edit database.props
6) change hp.Database.hostName=
7) change hp.Database.instance=
8) Edit *-ds.xml with new hostname and instance (in\jboss\server\hpsim\deploy)
-and-
there may be another file with a name like "tmpXXXXXpmp-ds.xml" in the folder \jboss\server\hpsim\tmp\deploy\ that you also should update.
10) START the HP SIM Service
11) wait for port 50000 to open
12) test.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-08-2011 06:10 AM
тАО07-08-2011 06:10 AM
Re: Migrating HP SIM Database into new SQL Server
Hello,
I am trying to move our HP SIM 6.2 database from a remote SQL 2005 server to a remote SQL 2008 server. I'm not a SQL person and that will be handled by our database admins.
After looking at the documentation and what others have said, I would assume have our DBSs just move the database and have me edit the
database.props, database.admin, databaseadminupd.tpl and databaseupdate.tpl files and follow the rest of the documentation for it to work???
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-07-2011 02:14 AM
тАО10-07-2011 02:14 AM
Re: Migrating HP SIM Database into new SQL Server
Hello everyone, this information was very important to me because it allowed me to change the database from one instance to another without any problem.
Thank you.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-28-2015 07:11 AM
тАО08-28-2015 07:11 AM
Re: Migrating HP SIM Database into new SQL Server
I'm aware this post is a bit old however it comes up at the top of Google search.
I'd like to add more detail to those migrating databases for current versions of Insight Control.
This should cover the complete suite.
\Program Files\HP\Systems Insight Manager\Config
database.admin
database.props
databaseadminupd.tpl
databaseupdate.tpl
\Program Files\HP\Systems Insight Manager\jboss\server\hpsim\deploy
hpsim-ds.xml
jtds-sqlserver-ds.xml
\Program Files\HP\Systems Insight Manager\jboss\server\hpsim\tmp\deploy
tmpXXXhpsim-ds.xml
tmpXXXjtds-sqlserver-ds.xml
\Program Files\HP\Insight Control virtual machine management\bin
hpvmmdb.conf
\Program Files\HP\Virtual Server Environment\conf
gwlmdb.properties
PMP_v5_0 database uses an ODBC connection.