3Right-click the source database and select Tasks > Detach.4Select the database and click OK.5When the detach operation is complete, copy the data files (.mdfand .ldf) to the destination machine'sdatabase folder.By default, the database folder is C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data.6In SQL Server Management Studio on the destination machine, right-click the Databasesdirectory andselect Attach.7Select the .mdffile that you copied to the destination machine's database folder and click OK.The database from the source machine is attached to the destination machine.What to do nextSee “Back Up VirtualCenter or vCenter Server Configuration with the Data Migration Tool,” on page 37.Back Up and Restore an Oracle DatabaseBefore you perform an upgrade to vCenter Server on a different machine, you might want to move the database.Moving the database is optional. To move an Oracle database, you perform a backup and restore operation.Consult your database administrator or see your database documentation about backing up and restoringdatabases.The machine with the VirtualCenter 2.5 or vCenter Server 4.0 database is called the source machine. Themachine on which the vCenter Server 4.1 database will reside is called the destination machine.vSphere Upgrade Guide36 VMware, Inc.
PrerequisitesVerify that you have a VirtualCenter 2.5 or vCenter Server 4.0 system running with a local or remote Oracle 10gor Oracle 11g database.Procedure1On the source machine, stop the VirtualCenter service.aSelect Start > Programs > Administrative Tools > Services.bRight-click VMware VirtualCenter Serverand select Stop.2On the source machine, log in to Oracle SQL*Plus as the VirtualCenter 2.5 or vCenter Server 4.0 databaseuser.3Export the database as a .dmpfile.4Copy the .dmpfile onto the C:\drive of the destination machine.5In Oracle SQL*Plus, run the following command to create the tablespace.create tablespace vctest datafile 'c:\vctest.dbf' size 100m autoextend on;6Run the following command to create a user. create user VCUSER identified by CENSORED default tablespace vctest;7Import the .dmpfile into the Oracle 64-bit database on the destination machine.8Verify that all the table data is imported.The original database is restored onto the new database, which you can use for the upgrade tovCenter Server 4.1.What to do nextSee “Back Up VirtualCenter or vCenter Server Configuration with the Data Migration Tool,” on page 37.Back Up VirtualCenter or vCenter Server Configuration with the DataMigration ToolUse the data migration tool to back up VirtualCenter or vCenter Server configuration data such as port settings,SSL certificates, and licensing information. The data migration tool can restore these settings when you upgradeto vCenter Server on a new 64-bit machine.