1. Login to NCM server from which you want to take the backup of database, and then set the VOYENCE_HOME environment variable.

    For example, in Linux, execute the following command:

    source /etc/voyence.conf

  2. Take the backup of database by using the backup.pl script under the <VOYENCE_HOME>/tools directory.

    The script creates a “backup-image-.*.tgz” file under the VOYENCE_HOME>/data-image directory.

    Note:
    • If you have Smarts Adapter configured with SMARTS IP and SAM, the backup.pl script will also backup the Smarts Adapter data.
    • If you are taking backup from lower version of NCM (10.1.3 and below) then before taking the backup run the database-changes.pl script present under Utils directory of 10.1.4 installer.
  3. Copy the “backup-image-.*.tgz” file to a host where a new NCM Combination setup is installed. The backup file can be copied under any directory.
  4. Login to the new NCM server setup, and then execute the following command:

    source /etc/voyence.conf

  5. Execute the following command from the <VOYENCE_HOME>/tools directory if you are restoring database across the same NCM version:

    perl restore.pl <Absolute path to backup image file /backup-image-.*.tgz>

  6. Execute the following command from the <VOYENCE_HOME>/tools directory if you are restoring database on higher NCM version:
    perl restore.pl <Absolute path to backup image file /backup-image-.*.tgz> --force
    Note: This step is recommended for the backups taken from NCM 10.1 version onwards.
  7. Update the InfraDB entry with the Device server host name. To update the InfraDB entry, perform the following steps:
  8. From the <VOYENCE_HOME>, execute the following command:

    \cgi-bin\cflist.cgi > cflist.txt

  9. Edit the cflist.txt to change the Device server FQDN to the new Device server FQDN (Same as Combination server FQDN).

    For example, POP 1000 “<hostname>”

  10. Execute the following command. It must return 'Status: 200 Success'.

    \cgi-bin\cfwrite.cgi < cflist.txt

  11. To update the Device server FQDN in cm_device_server table in the database, do the following:
  12. Login to NCM UI, and then navigate to Tools > System Administration > Global > Access > Device Servers.

  13. Select the Device server, and then click Edit.

  14. In the Edit Device Server window, click OK.

    Or,

    Run the following command from [Product directory]\db\controldb\bin: 

    psql.exe -h -d voyencedb -U pgdba -p 5435 -c "update cm_device_server set device_server_name='Device_Server_name';"
  15. If you have Smarts Adapter configured in your previous NCM setup, follow these steps:

    On Linux

  16. Stop the NCM Smarts Adapter service.

    service ncmsmartsadapter stop

  17. Change the directory to $VOYENCE_HOME/NCMSmartsAdapter/.
  18. Open and edit the prodDb.script file, so that VOYENCE_CONFIGURATION table and SMARTS_CONFIGURATION table is populated with actual AS host name, as follows:
  19. Search for

    INSERT INTO VOYENCE_CONFIGURATION VALUES (1,4,TRUE,'auth.conf','2','10000','linbgh125.lss.vmware.com','jUpFF0M5HQuOdJUqIYKo0w==','sysadmin')

  20. Replace the old Application server host name with new Application server host name.

    For example, replace 'linbgh125.lss.vmware.com' with '<new Application server host name>'.

  21. Search for

    INSERT INTO SMARTS_CONFIGURATION VALUES (1,5,'aced0005757200135b4c6a6176612e6c616e672e537472696e673badd256e7e91d7b4702000078700000000274000e494e4348415247452d414d2d504d74000353414d','10.31.202.131',426,NULL,'z/RS9si+EWVsdA8kxzEovg==','SAM','linbgh131.lss.vmware.com','10.31.202.131','z/RS9si+EWVsdA8kxzEovg==','46499','admin',TRUE,'admin','linbgh125.lss.vmware.com')

  22. Replace the old Application server host name with new Application server host name.

    For example, replace 'linbgh125.lss.vmware.com' with '<new Application server host name>'.

  23. Open and edit the prodDb.script file, so that TOPOLOGY_SYNC table is populated with actual DS host name, as follows:
  24. Search for

    INSERT INTO TOPOLOGY_SYNC VALUES (1,43,120,300,TRUE,TRUE,200,'INCHARGE-AM-PM','DisplayName','Active Sync On',NULL,TRUE,FALSE,TRUE,TRUE,TRUE,TRUE,FALSE,'linbgh127.lss.vmware.com','1000','Derived','IP Devices','Run Upon Approval')

  25. Replace the old device server host name with the new device server host name.

    For example, replace 'linbgh127.lss.vmware.com' with '<new Device server host name>'.

  26. Stop the NCM Smarts Adapter service.

    sc stop VcSmarts (DOS command)

  27. Change the directory to %VOYENCE_HOME%/NCMSmartsAdapter/.
  28. Open and edit the prodDb.script file, so that VOYENCE_CONFIGURATION table and SMARTS_CONFIGURATION table is populated with actual AS host name, as follows:
  29. Search for

    INSERT INTO VOYENCE_CONFIGURATION VALUES (1,4,TRUE,'auth.conf','2','10000','linbgh125.lss.vmware.com','jUpFF0M5HQuOdJUqIYKo0w==','sysadmin')

  30. Replace the old Application server host name with new Application server host name.

    For example, replace 'linbgh125.lss.vmware.com' with '<new Application server host name>'.

  31. Search for

    INSERT INTO SMARTS_CONFIGURATION VALUES (1,5,'aced0005757200135b4c6a6176612e6c616e672e537472696e673badd256e7e91d7b4702000078700000000274000e494e4348415247452d414d2d504d74000353414d','10.31.202.131',426,NULL,'z/RS9si+EWVsdA8kxzEovg==','SAM','linbgh131.lss.vmware.com','10.31.202.131','z/RS9si+EWVsdA8kxzEovg==','46499','admin',TRUE,'admin','linbgh125.lss.vmware.com')

  32. Replace the old Application server host name with new Application server host name.

    For example, replace 'linbgh125.lss.vmware.com' with '<new Application server host name>'.

  33. Open and edit the prodDb.script file, so that TOPOLOGY_SYNC table is populated with actual DS host name, as follows:
  34. Search for

    INSERT INTO TOPOLOGY_SYNC VALUES (1,43,120,300,TRUE,TRUE,200,'INCHARGE-AM-PM','DisplayName','Active Sync On',NULL,TRUE,FALSE,TRUE,TRUE,TRUE,TRUE,FALSE,'linbgh127.lss.vmware.com','1000','Derived','IP Devices','Run Upon Approval')

  35. Replace the old device server host name with the new device server host name.

    For example, replace 'linbgh127.lss.vmware.com' with '<new Device server host name>'.