Submit a ticketCall us

WebinarUpcoming Webinar: How Help Desk and Remote Support Pays for Itself

Learn how help desk software can simplify ticketing management, allow you to track hardware and software assets, and accelerate the speed of IT support and service delivery. Gain insights on how remote support tools allow your IT team to maximize their efficiency and ticket resolution by expediting desktop troubleshooting, ultimately helping keep end-users happy and productive.

Register here.

Home > Success Center > Web Help Desk (WHD) > Web Help Desk (WHD) Documentation > 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: 588 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