Submit a ticketCall us

WebinarFREE IT Monitoring Webcast

Don’t miss out on our webcast, Essential IT Monitoring with SolarWinds ipMonitor, where we will show you how to keep an eye on your IT environment from one centralized, affordable, and lightweight monitoring tool: SolarWinds® ipMonitor®.

Register now.

Home > Success Center > Web Help Desk (WHD) > Web Help Desk (WHD) Documentation > Web Help Desk Administrator Guide > WHD Installation requirements > Database migration options

Database migration options

Created by Steve.Hawkins, last modified by Anthony.Rinaldi_ret on Jul 18, 2016

Views: 786 Votes: 0 Revisions: 5

Web Help Desk uses an embedded PostgreSQL database for a standard database. If you upgrade to Web Help Desk v12.1.0 and later with an embedded FrontBase database, the Web Help Desk installation wizard assists you with upgrading the existing database to an embedded PostgreSQL database.

To avoid future update issues, SolarWinds strongly recommends migrating your data before you update Web Help Desk to the next version.

SolarWinds does not provide support, tools, or assistance with database migration. For information about migrating your database using a third-party tool, contact the tool vendor for assistance.

Run Web Help Desk on embedded and external JAVA

Beginning in WHD 12.2, Web Help Desk for OS X includes an embedded Java Virtual Machine (JVM). If you
are running an external Oracle JVM, Web Help Desk will preserve your Java settings during the installation
procedure and continue using the external Oracle JVM.

If you are migrating from an external JVM to the embedded JVM included with Web Help Desk and you are
using a MySQL database, ensure that the new embedded Java directory on your Web Help Desk server
includes an Oracle Java Database Connectivity (JDBC) driver.

External database options

Web Help Desk supports SQL Server 2008, SQL Server 2012, and MySQL 5.5 as external databases. You can also use an external PostgreSQL 9.2 or PostgreSQL 9.3 database with Web Help Desk v12.0.0 and later.

If you are using an Oracle or OpenBase database, use a migration tool that migrates your data to a
supported database (such as PostgreSQL, MySQL, or SQL Server). Use caution when choosing target
data types to use in one of the supported databases. If Web Help Desk does not support the data
type, you may experience unexpected results when upgrading to the latest version.


Last modified