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

10
17.
Click
Next
. The
Choose a destination
dialog box appear
s.
18.
Select the new database created in step 10 and click
Next
.
19.
For
Specify Table copy or Query
, leave the default settings and click
Next
.
20.
In the
Select Source Tables and Views
wizard, select all of the tables and views and
click
Next
.
21.
Review the
Summary
an
d click
Finish
. The export process starts immediately. A message
appears:
Successfully copied objects from Microsoft SQL Server to SQL Server
.
22.
Click
Done
.
Migrating PMP 4.x.x data from the source CMS to the target CMS
To migrate PMP 4.x.x data from the
source CMS system to the target CMS system:
1.
Login to the database system as administrator.
2.
To launch Enterprise Manager, select
Start

Programs

Microsoft SQL
Server

Enterprise Manager.
3.
From
Enterprise Manager
, open
Microsoft SQL Servers

SQL Servers group
-
><
local
database instance
>
>
Databases.
Note
: The
<
local database name
>
in most cases is
local
or it could be the instance you
specified.
4.
From the right pane, right
-
click on the database
PMP_V3_0
,
which is the PMP database on
the target CMS, and select
All Tas
ks

Import Data.
The
DTS import/Export
wizard
appears.
5.
Select
Next.
The
Choose Data Source
dialog box appears.
6.
Select the source CMS as the server select
PMP_V3_0
as the database and click
Next.
7.
From the
Choose destination
page, select
local
(Database syste
m) as the server, and
PMP_V3_0
as the database and select
Windows Authentication
or
SQL Server
Authentication
as the required authentication and click
Next
.
8.
Select
Copy objects and data between SQL Server databases
and click
Next
.
9.
Select
Include extended p
roperties
and leave all the other default options as selected.
10.
Click
Next
. The
Save, schedule and replicate Package
page appears.
11.
Retain the
default options and click
Next
.
12.
Review the summary and click
Finish
. The export process starts immediately.
13.
A mess
age appears:
Successfully copied objects from Microsoft SQL Server to
SQL Server
.
14.
Click
Done
.
Note:
To migrate PMP 4.x.x data from the source CMS to the target CMS
with a local SQL Express
2005 database follow the same steps provided in “Importing the SQL
Server 2005 Express
database” section.