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.
This fling is available on VMware Flings.
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.
- 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)
- 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