How To Migrate The VMware vCenter Database

IT Support Forum Forums Virtualization VMware vCenter Installation How To Migrate The VMware vCenter Database

Tagged: 

This topic contains 0 replies, has 1 voice, and was last updated by  Webmaster 3 years ago.

  • Author
    Posts
  • #585

    Webmaster
    Keymaster

    There are a number of scenarios in which you may wish to migrate the VMware vCenter database. To migrate the vCenter database:

    1. Log onto the vCenter server
    2. Stop the VMware services
    3. Backup the Virtual Center database using SQL Management Studio
    4. Restore the Virtual Center database onto the new server
    5. Click Start -> Administrative Tools -> Data Sources (ODBC)
    6. Click on the System tab
    7. Select the VirtualCenter DSN
    8. Click Configure and configure the DSN to point to the new SQL server

      ❗ You may need to download and install the Microsoft SQL Server 2008 R2 (Or whatever version of SQL server you are migrating to) Feature Pack to the vCenter server, then update the DNS to the new SQL driver (Requires that you delete the DSN and recreate it)

      ❗ Make sure you click Test Connection when setting up the ODBC connection otherwise you may be unable to start the VMware services after migrating the database

      ❓ Alternatively you can modify the DSN through the registry if you don’t know your details:

      Click Start > Run, type regedit, and click OK
      Navigate to HKEY_LOCAL_MACHINE\SOFTWARE\VMware, Inc\VMware VirtualCenter
      Modify the key DbInstanceName and remove the current Value data
      Modify the key DbServerType and change the Value data from Bundled to Custom if required
      Navigate to HKEY_LOCAL_MACHINE\SOFTWARE\VMware, Inc\VMware VirtualCenter\DB
      Modify Key 4 and change the ODBC driver to the new driver if required
      Modify key 2 and add the vCenter SQL Server user, for example sa

    ❗ If you want to change the SQL password, run the following command in the command prompt:

    C:\Program Files\VMware\Infrastructure\VirtualCenter Server\vpxd.exe -p

    After migrating the VMware vCenter database, you need to check that the jobs and stored procedures point to the vCenter database. There should be 10 jobs and 31 stored procedures, none of which should be pointed at the Master or Temp databases.

    Finally, start the VMware services on the vCenter server to complete the database migration process.

You must be logged in to reply to this topic.