If you choose to migrate from an external or unsupported database to a PostgreSQL database, stop WHD 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 data types used in previously and currently supported WHD databases.
See the PostgreSQL Wiki website for information about migrating from an external or unsupported database to a PostgreSQL database.
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.
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
- Download the SQL Server Migration Assistant (SSMA) from the Microsoft website at www.microsoft com.
- Stop WHD.
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.
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.
- Start WHD.
- Change your database settings to connect WHD to your new SQL Server database.
- 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.