Migrate vCloud Director Database from MSSQL to Postgres

As vcloud director 9.5 is the last iteration to support MS SQL we decided to migrate the database to Postgres

Here are the instructions to migrate the database

 

Pre-requisites

1) Snapshot all Cells
2) Snapshot MSSQL DB
3) Backup MSSQL DB

 

Procedure:

4) Shutdown all cells

 service vmware-vcd stop

    
5) On first cell

cd /opt/vmware/vcloud-director/bin
./cell-management-tool dbmigrate -dbhost 10.0.0.1 -dbport 5432 -dbuser vcloud -dbname vclouddb -dbpassword 'password' -verbose
./cell-management-tool reconfigure-database -dbhost 10.0.0.1 -dbport 5432 -dbuser vcloud -dbname vclouddb -dbpassword 'password' -dbtype postgres

    
6) Run reconfigure-database on all other cells

cd /opt/vmware/vcloud-director/bin
./cell-management-tool reconfigure-database -dbhost 10.0.0.1 -dbport 5432 -dbuser vcloud -dbname vclouddb -dbpassword 'password' -dbtype postgres

7) start all cells

service vmware-vcd start