HP Device Manager 4.6 - Database Troubleshooting Guide

– In MS SQL Server, it needs the minimum privileges db_datareader and db_datawriter.
Using PostgreSQL
PostgreSQL is automatically installed and runs in the background on the same device as the HDPM Server. Becauser there is
only one PostgreSQL database instance, you do not need to configure the database.
Troubleshooting steps
Migrate Database
Migrate Database is a function during the HPDM installation process that does two things.
• It updates the source database schema to the current schema if there are any changes.
• It lets you migrate the source database to another place. For example, you can migrate from PostgreSQL to MS SQL
Server, from MS SQL Server to PostgreSQL, or from MS SQL Server to another MS SQL Server.
Backup and Restore Tool
The Backup and Restore Tool is a standalone tool that helps back up the current HPDM database, templates, tasks, and
template plugin files. It can restore data to the same version of HPDM and the same database type only. For example, if you
back up a MS SQL Server database, you can only restore it to a MS SQL Server database. HP does not recommend restoring
the data to different versions of MS SQL Server.
3