Migrating Windows VC with MSSQL to VCSA with Postgres DB


Earlier it was not possible to migrate windows based vCenter Server installation with MS-SQL database to vCenter Server Appliance with embedded Postgres DB. But now it is possible to achieve this using a fling called VCS to VCSA Converter. 

Here is a diagram to visualize this process.

vcs-to-vcsa-converter-appliance-diagram

This fling is available on VMware Flings.

Summary

The VCS to VCVA Converter Appliance allows customers to migrate from Windows vCenter Server with an External Microsoft SQL Server Database to the vCenter Server Appliance with an embedded vPostgres database. The Fling migrates the vCenter database, roles, permissions, privileges, certificates and inventory service. The target appliance will run at the same IP address as the source vCenter.

vcs to vcsa

System Requirements

  • vCenter Server running on Windows – vSphere 5.5 or greater
  • The Windows vCenter Server and the vCenter Server Appliance should be running the same version (e.g. vCenter Server Windows 5.5u1 to VCSA 5.5u1)
  • The vCenter Server Appliance should be deployed with at least the same number of CPUs and at least the same amount of memory as the Windows vCenter Server host
  • vCenter Components (Inventory Service, vSphere Web Client and VMware Single Sign On) must be running on the same host as the vCenter Server
  • External Microsoft SQL Server 2008R2 or later for the vCenter Database (VCDB)
  • vSphere Web Client Plugins connected registered with an Active Directory user
  • VMware Single Sign On User/Groups are currently not migrated (require re-registration)
  • Migration Appliance must be able to communicate with the Windows vCenter Server Database and its database as well as the new vCenter Server Appliance. The following ports are used for this communication and should be open on the vCenter Windows server and on the VCSA:
  • Ports: 22 (ssh), 443 (https), 445 (SMB)

Limitations:

  • Microsoft SQL Server and vCenter Server must be on separate hosts
  • Microsoft SQL Express Database is not supported in version 0.9
  • VMware Single Sign On Users and Groups are not migrated in version 0.9
  • Windows Local Users and Groups are not migrated in version 0.9
  • vCenter Alarm action scripts are not migrated in version 0.9
  • The migration will require some downtime for the vCenter Server
  • Linked Mode configuration is not migrated. Multiple vCenters must be migrated separately
  • Any VMware or 3rd party vSphere Web Client plug-ins (e.g. VUM, NSX) that are running on the same host as the vCenter Server will not be migrated

You can watch the below video to walkthrough the process

About Alex Hunt

Hi All I am Manish Kumar Jha aka Alex Hunt. I am currently working in VMware Software India Pvt Ltd as Operations System Engineer (vCloud Air Operations). I have around 5 Years of IT experience and have exposure on VMware vSphere, vCloud Director, RHEL and modern data center technologies like Cisco UCS and Cisco Nexus 1000v and NSX. If you find any post informational to you please press like and share it across social media and leave your comments if you want to discuss further on any post. Disclaimer: All the information on this website is published in good faith and for general information purpose only. I don’t make any warranties about the completeness, reliability and accuracy of this information. Any action you take upon the information you find on this blog is strictly at your own risk. The Views and opinions published on this blog are my own and not the opinions of my employer or any of the vendors of the product discussed.
This entry was posted in Vmware. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s