Utility Tools

You can use a database management utility tool to perform database backups and restores. This tool can be operated via the command line and is available in the base installation folder (where IntegrityCentre.exe is stored).

Note

This tool is only available for On-Premise or Offshore deployments, it’s not available for Software as a Service (SaaS).

See below for detailed information about its usage:

Name	Command	Example Usage	Description
Help	-h	DBManagement.exe -h	Provides information about usage, example and parameters for each of the Backup, Restore, and Restore (with Credentials) commands.
Backup	/backup	DBManagement.exe /backup /sql=MySQLServer /db=MyDatabase /username=admin /password=admin /path="C:\Database Backups"	Tells NEXUS IC to backup a database. For example, it can be used for automated backups of a live database.
Restore	/restore	DBManagement.exe /restore /sql=MySQLServer /db=NewDatabase /path="C:\Database Backups\MyDatabase.nexus-backup"	Tells NEXUS IC to restore a database. For example, it can be used for automated refreshing of a sandpit database.
Restore (with Credentials)	/restore	DBManagement.exe /restore /sql=MySQLServer /db=NewDatabase /path="C:\Database Backups\MyDatabase.nexus-backup" /username=admin /password=admin	If you are overwriting an existing database, you must additionally supply credentials, to demonstrate that you have the appropriate authority to overwrite.