6.0.2

Table Of Contents
6 For vCenter Server 5.5, run the cleanup script.
a Locate the cleanup_orphaned_data_MSSQL.sql script in the ISO image and copy it to the Microsoft
SQL server.
b Log in to your database.
n
For Microsoft SQL Server Express, open a command prompt.
n
For Microsoft SQL Server, log in to a Microsoft SQL Server Management Studio session as the
vCenter Server database user.
c Run the cleanup script.
For Microsoft SQL Server Express, run:
sqlcmd -E -S localhost\VIM_SQLEXP -d VIM_VCDB -i pathcleanup_orphaned_data_MSSQL.sql
For Microsoft SQL Server: run the cleanup_orphaned_data_MSSQL.sql contents.
Make sure that you are connected to the database used by vCenter Server.
The cleanup script cleans any unnecessary data in your vCenter Server database.
7 Make a full backup of the vCenter Server database.
Your database is prepared for the vCenter Server migration to vCenter Server Appliance.
Prepare Managed ESXi Hosts for Migration
You must prepare the ESXi hosts that are managed by your vCenter Server installation before migrating it
from Windows to an appliance.
Prerequisites
To migrate vCenter Server or vCenter Single Sign-On from Windows to an appliance, your source and target
ESXi hosts must meet the migration requirements.
n
ESXi hosts must be at version 5.5 or greater. If your ESXi hosts are at an earlier version than 5.5,
upgrade them to 5.5. Read and follow all best practices when upgrading your hosts to ESXi 5.5.
n
The target ESXi host must not be in lockdown or maintenance mode.
Procedure
1 If you have Custom or Thumbprint certicates, see “Host Upgrades and Certicates,” on page 29 to
determine your preparatory steps.
2 Run vCenter Host Agent Pre-Upgrade Checker.
3 If you have vSphere HA clusters, SSL certicate checking must be enabled.
If certicate checking is not enabled when you upgrade, vSphere HA fails to congure on the hosts.
a Select the vCenter Server instance in the inventory panel.
b Select the Manage tab and the General subtab.
c Verify that the SSL  eld is set to vCenter Server requires  host SSL .
Your ESXi hosts are ready for vCenter Server upgrade.
vSphere Migration
28 VMware, Inc.