Submit a ticketCall us

Get a crash course on Network Monitoring delivered right to your inbox
This free 7-day email course provides a primer to the philosophy, theory, and fundamental concepts involved in IT monitoring. Lessons will explain not only how to perform various monitoring tasks, but why and when you should use them. Sign up now.

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: 70 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
15:36, 18 Jul 2016

Tags

Classifications

Public