This is a quick resource on how to easily and successfully move vCenter/View databases from one SQL server to another. We’re only covering the vCenter server side. If you have access to SQL Management Studio, I assume to are capable of moving a database.
vCenter
- Stop vCenter service
- Back up and move the database to the new database server
- Update the database connection with new server [Start > Administrative Tools > Data Sources (ODBC) > System DSN]
- Start vCenter service
- Recreate SQL Agent jobs (see this KB)
Update Manager
- Stop Update Manager service
- Back up and move the database to the new database server
- Update the database connection [%SystemRoot%syswow64odbcad32.exe > System DSN]
- Start Update Manager service
For more information on vCenter and Update Manager, reference this VMware KB article.
View Composer
- Stop Composer service
- Back up and move the database to the new database server
- Update the database connection with new server [Start > Administrative Tools > Data Sources (ODBC) > System DSN]
- Start Composer service
View Events
- Move the database
- Log in to View Administrator and navigate to View Configuration > Event Configuration
- Select “Edit…” in the Event Database section
- Update the fields with information from the new server and hit OK.