• Skip to primary navigation
  • Skip to main content

jdgreen.io

The personal blog of James Green

  • Home
  • Technology
    • Announcements
    • Industry
    • Reviews/Guides
    • Tech Field Day
    • Interviews
  • Health
    • Food
    • Biohacking
    • Fitness
  • Faith
  • Book Notes
    • Business Books
    • Faith Books
    • Health Books
    • Technology Books
  • About
  • Show Search
Hide Search

Migrate VMware Databases

James Green · Jan 15, 2014 ·

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

  1. Stop vCenter service
  2. Back up and move the database to the new database server
  3. Update the database connection with new server [Start > Administrative Tools > Data Sources (ODBC) > System DSN]
  4. Start vCenter service
  5. Recreate SQL Agent jobs (see this KB)

Update Manager

  1. Stop Update Manager service
  2. Back up and move the database to the new database server
  3. Update the database connection [%SystemRoot%syswow64odbcad32.exe > System DSN]
  4. Start Update Manager service

For more information on vCenter and Update Manager, reference this VMware KB article.

View Composer

  1. Stop Composer service
  2. Back up and move the database to the new database server
  3. Update the database connection with new server [Start > Administrative Tools > Data Sources (ODBC) > System DSN]
  4. Start Composer service

View Events

  1. Move the database
  2. Log in to View Administrator and navigate to View Configuration > Event Configuration
  3. Select “Edit…” in the Event Database section
  4. Update the fields with information from the new server and hit OK.

VMware database, vcdb

James Green is an enterprise IT consultant, a product of an amazing IT community, and a partner in ActualTech Media. He is a serial vExpert designee and a passionate Tech Field Day delegate and supporter. » Read Full Bio...

James Green: View My Blog Posts

Copyright © 2023 · Monochrome Pro on Genesis Framework · WordPress · Log in

Posting....