Submit a ticketCall us

Cloud Workloads: Meet Your New Hybrid IT Reality
Have you found yourself in that evolving, hybrid IT grey area and wondering if cloud workloads are now part of your purview? And if so, will monitoring cloud workloads require a new set of dedicated cloud monitoring tools? Your answers: yes, they should be, and no, they don’t.

Find out how SolarWinds® Server & Application Monitor (SAM) can help you monitor your cloud workloads side by side with your on-premises workloads. Register Now.

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

Database migration options

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

Views: 162 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

Tags

Classifications

Public