Moving HP SIM 5.x to a new Windows system (441289-003, January 2009)

9
s.
Click
Select Objects
. In the
Select Objects
dialog box, select only the
R_ArrayControllers
object.
t.
Click
OK
.
u.
Click
Next
.
v.
Retain the
default options and click
Next
.
w.
Review the Summary and click
Finish
. The export process starts immediately. A message
appears:
Successfully copied objects from Microso
ft SQL Server to SQL
Server
.
x.
Click
Done
.
35.
Click
Done
.
Importing the SQL Server 2005 Express database from the source CMS
to the target CMS
Note: SQL Server 2005 Express cannot be connected to MS SQL 2000.
While installing HP SIM 5.2 on the target CMS, be
sure that it is pointing to the correct database
system where SQL 2000 is running.
To import the
SQL Server 2005 Express
database from the source CMS to the target CMS:
1.
Install HP SIM 5.2 on the target CMS with remote SQL 2005.
2.
Go to
Control Panel

Adminis
trative Tools

Services
and stop the HP SIM, HP
Performance Management Pack, and HP PMP Tools services.
3.
On the target system, run the command mxgetdbinfo, to get the database name. For
example,
Insight_v50_0_22013812.
4.
Logon to the database system, as Admini
strator.
5.
Install the Client Management Tools on the database system.
6.
Select
Start

Programs

Microsoft SQL Server 2005

SQL Server Management
Studio.
7.
In the
Connect to server
wizard, select the local system as server and click
Connect
.
8.
Click the
Connect
tab
in the left panel and select
Database Engine
.
9.
In the
Connect to Server
wizard, select the source CMS and
Authentication mode
and
click
Connect
.
10.
To rename the database, right click on the target CMS database and select
rename
.
11.
Right click on the database an
d select
New Database
.
12.
In the
New Database
wizard, name the new database with the same name as as the old
target database name. For example,
Insight_v50_0_22013812
.
13.
Create a new database with same old target database name.
14.
Right click on source database, s
elect
Tasks

Export Data
15.
The
Welcome to SQL server Import and Export wizard
displays. Click
Next
.
16.
Select the source CMS (SQL server 2005 Express) as the server and the database as
Insight_v50_0<
xxxx
>.