6.5.1

5 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 a
location accessible by 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
path/cleanup_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.
6 Make a full backup of the vCenter Server database.
Your database is prepared for the vCenter Server migration to vCenter Server Appliance.
Prepare PostgreSQL Database Before Migrating vCenter Server to an
Appliance
Ensure that you have the necessary credentials, and that you complete any necessary cleanup or other
preparation before migrating your PostgreSQL database installation on Windows to an appliance.
For information about backing up the vCenter Server database, see the PostgreSQL documentation.
Prerequisites
Verify that you have confirmed basic migration interoperability before preparing your PostgreSQL
database for migrating vCenter Server.
Procedure
1 Verify that passwords are current and not set to expire soon.
2 For vCenter Server, locate the cleanup_orphaned_data_PostgresSQL.sql script in the ISO image
and copy it to your PostgreSQL server.
3 Log in to vCenter Server Appliance as root user.
vSphere Upgrade
VMware, Inc. 173