HP Device Manager 4.6 - Database Troubleshooting Guide

ManualsBrandsHP ManualsSoftwareHP Device Manager

Technical white paper

HP Device Manager 4.6

Database Troubleshooting Guide

Table of contents

Overview .......................................................................................................................................................................................... 2

Using MS SQL Server ..................................................................................................................................................................... 2

Using PostgreSQL .......................................................................................................................................................................... 3

Troubleshooting steps ................................................................................................................................................................. 3

Migrate Database ...................................................................................................................................................................... 3

Backup and Restore Tool ........................................................................................................................................................ 3

For more information ................................................................................................................................................................... 4

HPDM Database Schema ......................................................................................................................................................... 4

Microsoft SQL Server ................................................................................................................................................................ 4

PostgreSQL ................................................................................................................................................................................. 4

Summary of content (4 pages)

PAGE 1
Technical white paper HP Device Manager 4.6 Database Troubleshooting Guide Table of contents Overview .......................................................................................................................................................................................... 2 Using MS SQL Server..................................................................................................................................................................... 2 Using PostgreSQL................
PAGE 2
Overview The purpose of this document is to give some background on the HPDM database and help customer to troubleshoot the database-related problems. HPDM can be used with two types of database: Microsoft® (MS) SQL Server and PostgreSQL. To use MS SQL Server, you must install and configure it yourself. PostgreSQL is an open-source database that is bundled with the HPDM Server. You do not need to install or configure it yourself.
PAGE 3
– 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.
PAGE 4
For more information HPDM Database Schema For HPDM database schema, see the HP Device Manager 4.6 Database Schema Guide. Microsoft SQL Server For more information on Microsoft SQL Server, go to http://msdn.microsoft.com/en-us/sqlserver/default. PostgreSQL For more information on PostgreSQL, go to http://www.postgresql.org/. Sign up for updates hp.com/go/getupdated © Copyright 2014 Hewlett-Packard Development Company, L.P. Microsoft and Windows are U.S.