5.8

1
Installing and Using the SQL Migration
Helper Tool
Installing and Using the VCM SQL Migration
Helper Tool
The VCM SQL Migration Helper Tool is a utility used to simplify the reconfiguration steps required to
perform a migration of a prior release of VMware vRealize Configuration Manager (VCM), EMC Ionix
Server Configuration Manager (SCM) 5.0 or later, or Configuresoft Enterprise Configuration Manager
(ECM) 4.11.1 or later. A “migration” upgrade is the process of using a new server with a new installation
of Windows Server 2008 R2, 2012, or 2012 R2 for the VCM Collector.
A migration upgrade requires you to:
1. Install all of the VCM prerequisites.
2. Copy the VCM databases and files to the new installation.
3. Point the installation or upgrade of VCM to the databases that you copied over instead of having the
VCM installation create new databases.
After you perform these steps, the installation or upgrade process will upgrade the databases you copied
over to the version of VCM you install.
When you copy databases to the new server, some data is not transferred automatically. For example:
n Scheduled jobs, which store their data in the SQL Server master system database (msdb).
n VCM user accounts and role assignments, whose data is stored in the SQL Server system database
master.
The SQL Migration Helper Tool can create SQL scripts to recreate the scheduled jobs, user accounts, and
role assignments on the new server after you copy the databases to the new server and attach them to
VCM.
Prerequisites
The SQL Migration Helper Tool supports migration upgrades from VCM 5.2.1 or later, EMC Ionix SCM 5.0
or later, and ECM 4.11 or later.
Before you run the SQL Migration Helper Tool, you must log in to Windows Server 2008 R2, 2012, or 2012
R2 on the new server using an account that has VCM, SCM, or ECM Admin access to the Collector.
For information to transfer and attach VCM databases, see the VCM Installation Guide.
Download and Install the SQL Migration Helper Tool
Download and install the SQL Migration Helper Tool from the VMware Web site.
VMware, Inc.
5