6.0.2

Table Of Contents

4 Verify that the JDBC driver le is included in the CLASSPATH variable.

5 Verify that permissions are set correctly.

6 Either assign the DBA role or grant the required permissions to the user.

7 For vCenter Server 5.5, run the cleanup script.

a Locate the cleanup_orphaned_data_Oracle.sql script in the ISO image and copy it to the Oracle

server.

b Log in to a SQL*Plus session with the vCenter Server database account.

c Run the cleanup script.

@pathcleanup_orphaned_data_Oracle.sql

The cleanup process purges unnecessary and orphaned data that is not used by any vCenter Server

component.

8 Make a full backup of the vCenter Server database.

Your database is prepared for the vCenter Server migration to vCenter Server Appliance.

Prepare a Microsoft SQL Server Database for Migration

Ensure that you have the necessary credentials, and that you complete any necessary cleanup or other

preparation before migrating your Microsoft SQL Server database on Windows to an embedded PostgreSQL

database appliance.

I You cannot use Integrate Windows for your authentication method if the vCenter Server

service is running under the Microsoft Windows built-in system account.

Prerequisites

Verify that you have backed up your database. For information about backing up the vCenter Server

database, see the Microsoft SQL Server documentation.

Procedure

1 Verify that passwords are current and not set to expire soon.

2 Verify that JDK 1.6 or later is installed on the vCenter Server machine.

3 Verify that the sqljdbc4.jar le is added to the CLASSPATH variable on the machine where

vCenter Server Appliance is to be migrated.

If the sqljdbc4.jar le is not installed on your system, the vCenter Server Appliance installer installs it.

4 Verify that your system database source name is using the Microsoft SQL Server Native Client 10 or 11

driver.

5 For vCenter Server 5.5, run the cleanup script.