HP Systems Insight Manager 6.3 Installation and Configuration Guide for Microsoft Windows

to encrypt the exported file for security reasons. The password you enter here will be required
to import the data.
• -f is optional. If you do not pass the filename, a Products.zip file is created in
[HPSIM]\data\configdata-export.
• -p is mandatory. Specify the password as part of the command or you will be prompted
to enter the password. The password must be a minimum of 8 characters. This password
is used to encrypt the exported file for security reasons. The password you enter here will
be required to import the data.
If a component (also known as Essentials or a plug-in) fails to export its data, the export
operation is not aborted. The data migration tool continues to execute the remaining
components.
Database tables and files that are specified in component specific configuration XML files are
exported.
Importing data from a CMS
1. Before data can be imported, the following requirements must be met:
• All operating system and database level user credentials on source CMS must be created
on target CMS.
• Target CMS must have HP Insight Software 6.3 or later installed.
• The CMS must be a clean installation and have no prior configurations.
NOTE: The import process deletes any existing data from the target CMS as the import
proceeds.
IMPORTANT: If data import fails for a component, the component database may lose its
data, and the component may become unstable. HP recommends that you take a snapshot
of all databases before proceeding with the import. The snapshot can be taken by running
the export operation on the target CMS, or your user specific backup method. If the import
fails, the database may be recovered from the snapshot. If one component fails during import,
the entire import operation fails. The import process deletes any existing data from the target
CMS as the import proceeds.
2. Copy the exported zip file to the target CMS. For example, from the source system copy
[HPSIM]\data\configdata-export\Products.zip to the destination CMS [HPSIM]\
data\configdata-import\Products.zip directory.
3. For remote databases the remote SQL server must have access to a local share.
a. The target CMS and the remote SQL are in the same domain.
b. On the target CMS, the folder [SIM]\data\configdata-import is shared.
c. In the remote DB server, the SQL service is running with the same user as the Administrator.
d. Enable xp_cmdshell in SQL Server 2005
4. To import your data, enter the following CLI command:
mximport [-f<filename.zip>] [-p password]
• -f is optional. If you do not pass the filename, the Products.zip is read from
[HPSIM]\data\configdata-import.
• -p is mandatory. Specify the password as part of the command or you will be prompted
to enter the password. The password must be the same password used to create the
export file.
Data migration 49