Database migration options

If you choose to migrate from an external or unsupported database to PostgreSQL, stop Web Help Desk and convert the datatypes in your old database to the data types used in the new database. Convert the data types before you migrate your data.

See Database datatypes for the database datatypes used in previously and currently supported Web Help Desk databases.

See the PostgreSQL Wiki website for information about migrating from an external or unsupported database to PostgreSQL.

Migration support

SolarWinds does not provide support, tools, or assistance with database migration. For information about migrating your external or unsupported databases using a third-party tool (such as PGAdmin3 or PostgreSQL Data Wizard), contact the tool vendor for assistance.

You can back up your PostgreSQL database using the command line in WHD or the Web Help Desk Administrator Console. If a Backup Failed error displays, see this KB article to resolve the issue.

Run WHD on embedded and external Java

WHD for macOS includes an embedded Java Virtual Machine (JVM). If you are running an external Oracle JVM, WHD preserves your Java settings during the installation procedure and continues using the external Oracle JVM.

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

Migrate from MySQL to SQL Server

  1. Download the SQL Server Migration Assistant (SSMA) from the Microsoft website at www.microsoft com.
  2. Stop Web Help Desk.
  3. Map identical database types located in MySQL and SQL Server (such as DATETIME) using SSMA.

    See the instructions included with the software for more information.

  4. Map inconsistent database types (such as DECIMAL in MySQL and money in SQL Server) manually using database mapping tables.

    See Database datatypes for a complete list of current and previous WHD database data types that include MySQL and SQL Server. SolarWinds recommends converting datatypes before you begin the migration process. SSMA does not support inconsistent datatypes.

  5. Start Web Help Desk.
  6. Change your database settings to connect WHD to your new SQL Server database.
  7. Continue the upgrade to the latest 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.