O'Reilly logo

vCenter Troubleshooting by Chuck Mills

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Migrating vCenter from SQL Express to SQL Server

While SQL Express is never recommended for a production environment, many times the setup of vCenter is completed with SQL Express for a Proof of Concept (POC), Pilot or a Test/Development environment. For various reasons, there might be a time you want or need to migrate from SQL Express to the full SQL Server. So, for whatever reason you might have to perform the process, here are the steps used to migrate from SQL Express to the full SQL version:

  • Migrate the SSO database (vCenter 5.1 only)
  • Migrate the vCenter Database
  • Change the vCenter ODBC connection
  • Recreate the SQL Jobs

But before you begin, here are a few items to document to make sure the migration goes as smoothly as possible:

  • Names of the databases ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required