Submit a ticketCall us

Looking to compare latest NPM features with previous versions of NPM?
The NPM new feature summary offers a comparison of new features and improvements offered with this release.

 

Home > Success Center > Web Help Desk (WHD) > Web Help Desk 12.5 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 on Jul 18, 2016

Views: 38 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