Server Management - Systems Insight Manager
1848730 Members
3638 Online
104036 Solutions
New Discussion

Re: mximport - import wipes out all data?

 
DanN_4
Occasional Advisor

mximport - import wipes out all data?

OK, we hare moving our SIM management server to a new host. We upgraded our old server to SIM 6 and did a mxexport which went fine. On the new server when we do a mximport we get this message:

Lookup HPSIM InstallPath (x86)
HPSIM InstallPath: C:\Program Files\HP\Systems Insight Manager
Lookup succeeded

WARNING! Import wipes out all data from the database.
Do you want to proceed (y/n):

This can't be good. I thought this was a migration utility and we certainly do not want the db to be wiped. according to the documentation we should be able to use this process, correct? I would have expected the data configuration to be wiped but not the db.

Here is what I found in the readme:

Migration New migration tool to transfer settings from a Systems Insight Manager 5.3.x Central
Management Server (CMS) to an Systems Insight Manager 6.0 CMS, and from a Systems Insight
Manager 6.0 CMS to another Systems Insight Manager 6.0 CMS.

Data migration
The data migration tool is a command line interface tool that you can use to migrate configuration data from
an installation of HP SIM 5.3.x or later to a new installation of HP SIM 6.0 running on another CMS. The
process leverages both an export and import tool to migrate the data. For example, you can use this tool to
migrate a HP SIM 6.0 system on a 32-bit operating system to a HP SIM 6.0 installation running on a 64-bit
Windows operating system. Configuration data includes user settings, discovered systems and their credentials,
as well as additional customizations made to HP SIM. You can use the migration tool to move the data from
a working HP SIM installation to a new system, or to backup and restore an HP SIM installation. Another
common use is to avoid an “in place” upgrade, this allows you to keep an older version of HP SIM in an
available and operational state as a source system and install a new version on a different server and import
the data. This tool only supports Windows operating system with a Microsoft SQL Server local or remote
database and can only be run by an operating system administrator.
6 REPLIES 6
JKytsi
Honored Contributor

Re: mximport - import wipes out all data?

Import is for totally clean and vanilla SIM6 system --> so You do not have data there to be lost.
Remember to give Kudos to answers! (click the KUDOS star)

You can find me from Twitter @JKytsi
DanN_4
Occasional Advisor

Re: mximport - import wipes out all data?

ok, but why would I want to migrate to a new system with a brand new db and loose all my servers and history. I was hoping this utility would copy all the setting from the old server and connect to the existing database. This is not the case then?
Change_happens
Honored Contributor

Re: mximport - import wipes out all data?

Hi Dan N, migration is to migrate data and configuration from your old setup to new one.

if you want to use existing DB then think of all data(DB) what u had previously? u want that to lost? some part of configuration is also stored in DB for that also it has to migrate old DB. what is your thought?
Rob Buxton
Honored Contributor

Re: mximport - import wipes out all data?

Dan,
I think you're reading that wrong.
What it's telling you is that the Import will overwrite anything in the new database.
That's what you want, all of that data to come into the new database.
What it doesn't do is add 5.3 data to an existing HP SIM 6.0 installation. It doesn't merge data.
DanN_4
Occasional Advisor

Re: mximport - import wipes out all data?

ok, so then it copies all the data from the old database to the new database then?
Change_happens
Honored Contributor

Re: mximport - import wipes out all data?

Correct!!