Submit a ticketCall us

Training Class Getting Started with SolarWinds Backup - February 28

This course offers customers an introduction to SolarWinds Backup, focusing on configuring the backup technology, taking backups, data restoration and data security. It is a great primer and will get you up to speed quickly on SolarWinds Backup.
Register for class.

Home > Success Center > Web Help Desk (WHD) > Web Help Desk Administrator Guide > Installation requirements > Migrate from MySQL to SQL Server

Migrate from MySQL to SQL Server

Table of contents
No headers
Created by Steve.Hawkins, last modified by Anthony.Rinaldi_ret on Jul 18, 2016

Views: 565 Votes: 0 Revisions: 4
  1. Download the SQL Server Migration Assistant (SSMA) from the Microsoft website at com.
  2. Stop Web Help Desk.

    Navigate to the <WebHelpDesk> directory and double-click whd_stop.bat.

  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 Web Help Desk 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.

    Navigate to the <WebHelpDesk> directory and double-click whd_start.bat.

  6. Change your database settings to connect Web Help Desk 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.

Last modified