Data migration of an existing Microsoft Windows CMS to a new Insight Management 7.0 system

Appendix G: Running fix_fqdn_dmt.pl script

This script updates existing values in the primary CMS database to be consistent with the current

secondary CMS FQDN. In HA migrations this script must be used to update the primary FQDN as

well.

Before running the script, make sure Perl and SQL cmd are installed on the primary CMS. The input

file is required, it must be formatted correctly, and it must not contain blank lines (even at the end).

Input file format

• One line is composed of the following:

<source_secondary_cms_fqdn>,<target_secondary_cms_fqdn>

• Each line is composed of a pair <from>,<to>. A file may be composed of multiple lines.

Example of an input file

oldsecondary1.company.domain,newsecondaryA.company.domain

oldsecondary2.company.domain,newsecondaryB.company.domain

cms-a15.domain,cms-a16.domain

Migration of high availability environments

You need to include the primary CMS’s HP SIM virtual server FQDN into the list if the primary CMS

is an HA CMS. This is also valid for secondary CMSs if they are HA CMS too.

Input file format

•One line is composed of the following:

• <source_primary_HPSIMVirtualServer_fqdn>,<target_primary_HPSIMVirtualSe

rver_fqdn>

•

<source_secondary_HPSIMVirtualServer_fqdn>,<target_secondary_HPSIMVirtu

alServer_fqdn>

Example of an input file with only the primary CMS in HA configuration

oldprimary-sim.company.domain,newprimary-sim.company.domain

oldsecondary1.company.domain,newsecondaryA.company.domain

oldsecondary2.company.domain,newsecondaryB.company.domain

Example of an input file for both primary and secondaries in HA configuration

oldprimary-sim.company.domain,newprimary-sim.company.domain

oldsecondary1-sim.company.domain,newsecondaryA-sim.company.domain

oldsecondary2-sim.company.domain,newsecondaryB-sim.company.domain

Summary

• The secondary CMS always needs to be added into the input file (HA environment or not).

• The primary CMS needs to be specified only when it is under HA configuration.

• You need specify the <HPSIMVirtualServer

>_fqdn instead of the usual <CMS FQDN> for all

nodes that are configured as HA.