Submit a ticketCall us

whitepaperYour VM Perplexities Called, and They Need You to Read This.

Virtualization can give you enormous flexibility with future workloads and can be a key enabler for other areas, like cloud computing and disaster recovery. So, how can you get a handle on the performance challenges in your virtual environment and manage deployments without erasing the potential upside? Learn the four key areas you need to be focusing on to help deliver a healthy and well-performing data center.

Get your free white paper.

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: 856 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