Submit a ticketCall us

Have You Auto Renewed? If not, you're missing out.
The SolarWinds Renewal Program comes with a host of benefits including the most recent product updates, 24/7 technical support, virtual instructor-led training and more. Experience all of this with the convenience of Auto Renewal, and never worry about missing any of these great benefits. Learn More.

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: 117 Votes: 0 Revisions: 4
  1. Download the SQL Server Migration Assistant (SSMA) from the Microsoft website at www.microsoft 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

Tags

Classifications

Public