• 网络与数据中心管理
  • 服务器与应用性能管理
  • IT服务管理
  • Windows AD域管理
  • 终端管理
  • IT安全
  • MSP
  • IT运维平台
 
 
应用性能管理(APM)
保证物理、虚拟、云环境的应用性能
 
 
简化终端设备管理
全面管控PC计算机、智能手机以及平板电脑,确保网络安全
 
 
IT运维外包服务工具
多租户模式,为您的客户提供更好的服务
IT运维管理平台
统一监控、集中运维
 

Migrate from:

ServiceDesk Plus to ServiceDesk Plus - MSP
Instructions
SupportCenter Plus to ServiceDesk Plus - MSP
Instructions
 
 
 
 

Note: If you are interested to migrate from any other tool, please send us the database model info and the sample data to msp-servicedeskplus-support@manageengine.com.

FAQs of Migration From ServiceDesk Plus to ServiceDesk Plus - MSP

1) What are the prerequisites for migrating ServiceDesk Plus to ServiceDesk Plus-MSP?

The prerequisites for migrating from ServiceDeskPlus to ServiceDeskPlus-MSP are mentioned below
  1. Make sure the build number of ServiceDeskPlus is higher or equal to 7509.
  2. Make sure there exists no assets in 'Not in any site' in ServiceDeskPlus.
  3. Make sure all license are mapped to a Site and not to 'Not in any site' in ServiceDeskPlus.
  4. Make sure there are no requester's in 'Not in any site' in ServiceDeskPlus.
  5. Make sure all the problems and changes are associated to requester's.
  6. Make sure all the cab members belongs to the same site

2) How can i find the build number of ServiceDesk Plus?

To know the build number, please click on the "About" link which is present in the top right of the ServiceDesk Plus user interface

3) My ServiceDesk Plus build number is less than 7509. How can i migrate to ServiceDesk Plus-MSP ?

Please upgrade your ServiceDesk Plus installation to the latest version by using the ServicePack's available here. Once you have upgraded to the latest version, follow the steps mentioned here to migrate to the ServiceDesk Plus-MSP

4) What informations can be migrated from ServiceDesk Plus to ServiceDesk Plus-MSP?

The below mentioned informations can be migrated from ServiceDesk Plus to ServiceDesk Plus-MSP.
  1. Request (Except ArchivedRequest if your ServiceDesk Plus version is 7600 or higher)
  2. Solutions
  3. Assets, IT-Assets, Non-ITAssets, AssetComponents, Scanned Software software Licenses (Except SoftwareLicense of Type Enterprise) Groups Static Groups
  4. Purchase
  5. Admin MSP Details, Roles, Technicians, Groups, Leave Types Category, Status, Level, Mode, Priority, Notification Rules, Helpdesk Customizer, Request-Additional Fields, Request Closing Rules, Request Template, Task Template, Requester - Additional Fields, Technician - Additional Fields, Sites, Operational Hours, Holiday, Departments, Preventive Maintainance Tasks, Active Directory, LDAP, Requesters Problem-Additional Fields, Problem Closure Rules, Change Types, Change Status, Change Advisory Board, Change Additional Fields, Change Closure Rules, Product Type, Product, Vendor, Workstation - Additional Fields, Asset - Additional Fields, Software Type, Software Category, Resource State, Purchase - Additional Fields, Purchase Default Values, Cost Center, GL Code, Contract - Additional Fields, Notification Rules, Self Service Portal

5) What are Accounts and how is it migrated from my ServiceDesk Plus?

Account represents a client of the MSP. For each site in ServiceDesk Plus we create an Account with the same name in ServiceDesk Plus - MSP and the Site is migrated as Site for that Account.

6) How to migrate from ServiceDesk Plus to ServiceDesk Plus-MSP?

Please check the prerequisites for migration(refer Q1). Then follow the steps below.
  1. If the version of ServiceDesk Plus adheres to the prerequisite then download the ServiceDesk Plus-MSP which is available here and install it.Please do not start the ServiceDesk Plus-MSP now.
  2. Download the migration tool based on your database :
    • For MySQL - download the DataMigration-MySQL.zip from here and extract the zip file in the Server where ServiceDesk Plus - MSP is installed
    • For MSSQL - download the DataMigration-MSSQL.zip from here and extract the zip file in the Server where ServiceDesk Plus - MSP is installed

    For MSSQL steps available here.

    For MySQL :
    • i) If ServiceDesk Plus and ServiceDesk Plus- MSP are installed in same server refer here.
    • ii) If ServiceDesk Plus and ServiceDesk Plus- MSP installed in different servers refer here.
  3. If you are using MSSQL server then follow the steps below :
    1. Navigate to <ServiceDeskPlus-MSP_Home>\bin directory
    2. Run ChangeDBServer.bat select MSSQL as server
      1. Enter the hostname on which the SQLServer is installed
      2. Enter the portnumber of the SQLServer
      3. Enter username and password
      4. Click save (Please do not bother if an error occurs saying "SQL Server is configured successfully. But you can not start the server".)
    3. Navigate to <ServiceDeskPlus-MSP_Home>\server\default\deploy
    4. Open the MSSQL-ds.xml file
      1. a)change the DataBaseName=Servicedesk in the connection-url to DataBaseName=ServiceDeskmsp
    5. Create a database with name as "servicedeskmsp" in the SQLServer.
    6. Start the ServiceDeskPlus-MSP server once and login using the userinterface to make sure the server has started.
    7. Shutdown the ServiceDeskPlus-MSP and ServiceDeskPlus server.
    8. Now open the sdp-msp-MSSQL.connection present under the <Extracted-zip-folder>/DataMigration6.0/projects/sdp-msp-MSSQL/

      DstXXX-represents the ServiceDeskPlus-MSP database parameters.

      SRcXXX-represents the ServiceDeskPlus database parameters.

      1. edit the SrcUserName,DstUserName give the username of the SQLServer for ex if the SQLServer username is say "sa" then change the values as
        SrcUserName=sa
        DstUserName=sa
      2. edit the DstPassword,SrcPassword give the password of the SQLServer for ex if the SQLServer password is say "secret" then change the values as DstPassword=secret SrcPassword=secret

        DstPassword=secret
        SrcPassword=secret
      3. edit the DSTUrl,SRCUrl in the connection file we can see DstURL=jdbc\:jtds\:sqlserver\://SQLSreverhostname\:1433/servicedeskmsp in the above url
        SQLServerhostname -- hostname in which the SQLServer is installed
        1433 -- the port on Which the SQLServer is running
        serviceDeskPlusmsp -- the name of the Destination Database for ex if your SQLServer is in a Server with hostname say SQLServer2008 with port 1488 then DstUrl will be DstURL=jdbc\:jtds\:sqlserver\://SQLServer2008\:1488/servicedeskmsp In the same way edit SrcUrl and save the file
    9. Go to <extractedfolder>/DataMigration 6.0/projects/sdp-msp-MySQL/ For windows open sdp-msp-MSSQL-commandline.bat replace set javahome=c:\ManageEngine\ServiceDeskPlus-Msp\jre with set javahome=<ServiceDeskPlus-MSP>\jre For Linux open sdp-msp-MSSQL-commandline.sh replace javahome=/home/test/ManageEngine/ServiceDeskPlus-MSP/jre/ with javahome=<ServiceDeskPlus-MSP>/jre/
    10. Now run the sdp-msp-MSSQL-commandline.bat/sh file present under the <Extracted-zip-folder>/DataMigration6.0/projects/sdp-msp-MSSQL/ Once the above steps were completed please goto step 5 :
  4. If you are using MySQL server follow the below steps :
    1. If Servicedesk Plus and ServiceDesk Plus - MSP installed in the same server
      1. Shutdown the ServiceDesk Plus Server.
      2. Goto <ServiceDeskPlus_Home>\bin directory.
      3. Execute - startdb.bat/sh(in case of linux) 33356
      4. Start the ServiceDeskPlus-MSP server once and login using the user interface to make sure the server has started.
      5. Shutdown the ServiceDeskPlus-MSP Server.
      6. Go to <ServiceDeskPlus-MSP_Home>\bin directory.
      7. Run startdb.bat.
      8. Go to <extractedfolder>/DataMigration 6.0/projects/sdp-msp-MySQL/ For windows open sdp-msp-MySQL-commandline.bat replace set javahome=c:\ManageEngine\ServiceDeskPlus-Msp\jre with set javahome=<ServiceDeskPlus-MSP>\jre For Linux open sdp-msp-MySQL-commandline.sh replace javahome=/home/test/ManageEngine/ServiceDeskPlus-MSP/jre/ with javahome=<ServiceDeskPlus-MSP>/jre/
      9. Run the sdp-msp-MySQL-commandline.bat/sh file present under the <extractedfolder>/DataMigration6.0/projects/sdp-msp-MySQL/
      10. Go to <ServiceDeskPlus_Home>\bin directory.
      11. Run stopdb.bat/sh 33356
      12. Go to <ServiceDeskPlus-MSP_Home>\bin directory
      13. Run stopdb.bat/sh

      Once the above steps were completed please goto step 5

    2. If ServiceDesk Plus and ServiceDeskPlus MSP installed in different Servers.
      1. Shutdown the ServiceDesk Plus Server.
      2. Goto <ServiceDeskPlus_Home>\bin directory.
      3. Execute - startdb.bat/sh(in case of linux) 33356
      4. Goto <ServiceDeskPlus_Home>\MySQL\bin directory
      5. Connect to the MySQL prompt by For windows Run MySQL -u root -P 33356 For Linux Run MySQL -u root -S ../MySQL/tmp/MySQL.sock
      6. Run grant ALL on *.* to 'root'@'<ServiceDeskMSP installed host name>'; for ex: grant ALL on *.* to 'root'@'servicedesk-test1'; where netflow-test1 is the name of the server where ServiceDesk is installed.
      7. Now open the sdp-msp-MySQL.connection file present under <extracted folder>\DataMigration6.0\Projects\sdp-msp-MySQL replace SrcURL=jdbc\:MySQL\://localhost\:33356/servicedesk?useStreamLengthsInPrepStmts\=false with SrcURL=jdbc\:MySQL\://<ServiceDesk hostname>\:33356/servicedesk?useStreamLengthsInPrepStmts\=false For ex: If ServiceDesk is installed in a machine with hostname say servicedesk-test1 then SrcURL=jdbc\:MySQL\://servicedesk-test1\:33356/servicedesk?useStreamLengthsInPrepStmts\=false
      8. Start the ServiceDeskPlus-MSP server once and login using the user interface to make sure the server has started.
      9. Shutdown the ServiceDeskPlus-MSP Server.
      10. Go to <ServiceDeskPlus-MSP_Home>\bin directory.
      11. Run startdb.bat.
      12. Go to <extractedfolder>/DataMigration 6.0/projects/sdp-msp-MySQL/ For windows open sdp-msp-MySQL-commandline.bat replace set javahome=c:\ManageEngine\ServiceDeskPlus-Msp\jre with set javahome=<ServiceDeskPlus-MSP>\jre For Linux open sdp-msp-MySQL-commandline.sh replace javahome=/home/test/ManageEngine/ServiceDeskPlus-MSP/jre/ with javahome=<ServiceDeskPlus-MSP>/jre/
      13. Run the sdp-msp-MySQL-commandline.bat/sh file present under the <extractedfolder>/DataMigration6.0/projects/sdp-msp-MySQL/
      14. Go to <ServiceDeskPlus_Home>\bin directory.
      15. Run stopdb.bat/sh 33356
      16. Go to <ServiceDeskPlus-MSP_Home>\bin directory
      17. Run stopdb.bat/sh

      Once the above steps were completed please goto step 5

  5. After the execution of the batch file.

    Copy the following folders custom, inline images, file attachments from the ServiceDeskPlus home directory and replace it under the ServiceDeskPlus-MSP Home directory.

    Now Start the ServiceDesk Plus - MSP server and login with administrator username and password of ServiceDesk Plus.

    Note:If you have queries regarding migration send an email to We will be glad to assist you.

FAQs of Migration From SupportCenter Plus to ServiceDesk Plus - MSP

 

  1. What are the prerequisites for migrating SupportCenter Plus to ServiceDesk Plus-MSP?
  2. How can i find the build number of SupportCenter Plus?
  3. My SupportCenter Plus build number is less than 7500. How can i migrate to ServiceDesk Plus-MSP ?
  4. What informations can be migrated from SupportCenter Plus to ServiceDesk Plus-MSP?
  5. How to migrate from SupportCenter Plus to ServiceDesk Plus-MSP?

 

(Q1) What are the prerequisites for migrating SupportCenter Plus to ServiceDesk Plus-MSP?

(A)The prerequisites for migrating from SupportCenter Plus to ServiceDeskPlus-MSP are mentioned below

  • Make sure the build number of SupportCenter Plus is higher or equal to 7500.
  • Make sure that User Created Status Name's are unique across Bussiness Units . i.e., Status Name apart from (Open ,Onhold, Closed, Request) are to be unique across Bussiness Units

 

(Q2) How can i find the build number of SupportCenter Plus?

A) To know the build number, please click on the "About" link which is present in the top right of the SupportCenter Plus user interface

(Q3) My SupportCenter Plus build number is less than 7500. How can i migrate to ServiceDesk Plus-MSP ?

A) Please upgrade your SupportCenter Plus installation to the latest version by using the ServicePack's available here.
Once you have upgraded to the latest version, follow the steps mentioned here to migrate to the ServiceDesk Plus-MSP

(Q4) What informations can be migrated from SupportCenter Plus to ServiceDesk Plus-MSP?

A)The below mentioned informations can be migrated from SupportCenter Plus to ServiceDesk Plus-MSP.

  • Request
  • Solutions
  • Accounts
  • Requesters

 

(Q5) How to migrate from SupportCenter Plus to ServiceDesk Plus-MSP?

A) Please check the prerequisites for migration(refer Q1). Then follow the steps below.

  1. If the version of SupportCenter Plus adheres to the prerequisite then download the ServiceDesk Plus-MSP which is available here and install it.Please do not start the ServiceDesk Plus-MSP now.
  2. Download the migration tool based on your database :

 

For MSSQL steps available here.

For MySQL :

  • If SupportCenter Plus and ServiceDesk Plus- MSP are installed in same server refer here.
  • If SupportCenter Plus and ServiceDesk Plus- MSP installed in different servers refer here.

 

For MSSQL steps available here

For MySQL :

  • If SupportCenter Plus and ServiceDesk Plus- MSP are installed in same server refer here.
  • If SupportCenter Plus and ServiceDesk Plus- MSP installed in different servers refer here.

3) If you are using MSSQL server then follow the steps below :

  • Navigate to <ServiceDeskPlus-MSP_Home>\bin directory
  • Run ChangeDBServer.bat select MSSQL as server
    1. Enter the hostname on which the SQLServer is installed
    2. Enter the portnumber of the SQLServer
    3. Enter username and password
    4. Click save
  • Navigate to <ServiceDeskPlus-MSP_Home>\server\default\deploy
  • Start the ServiceDeskPlus-MSP server once and login using the userinterface to make sure the server has started.
  • Shutdown the ServiceDeskPlus-MSP and SupportCenter Plus server.
  • Now open the scp-sdpmsp-mssql.connection present under the
    <Extracted-zip-folder>/DataMigration6.0/projects/scp-sdpmsp-mssql/
    DstXXX-represents the ServiceDeskPlus-MSP database parameters.
    SRcXXX-represents the SupportCenter Plus database parameters.
    1. edit the SrcUserName,DstUserName give the username of the SQLServer
      for ex if the SQLServer username is say "sa"
      then change the values as
      SrcUserName=sa
      DstUserName=sa
    2. edit the DstPassword,SrcPassword give the password of the SQLServer
      for ex if the SQLServer password is say "secret"
      then change the values as
      DstPassword=secret
      SrcPassword=secret
    3. edit the DSTUrl,SRCUrl
      in the connection file we can see
      DstURL=jdbc\:jtds\:sqlserver\://SQLSreverhostname\:1433/servicedesk
      in the above url
      SQLServerhostname -- hostname in which the SQLServer is installed
      1433 -- the port on Which the SQLServer is running
      serviceDeskPlus -- the name of the Destination Database
      for ex if your SQLServer is in a Server with hostname say SQLServer2008 with port 1488
      then DstUrl will be
      DstURL=jdbc\:jtds\:sqlserver\://SQLServer2008\:1488/servicedesk
      In the same way edit SrcUrl and save the file
    4. Go to <extractedfolder>/DataMigration 6.0/projects/scp-sdpmsp-mssql/
      For windows
      open scp-sdpmsp-mssql-commandline.bat
      replace
      set javahome=c:\ManageEngine\ServiceDeskPlus-Msp\jre
      with
      set javahome=<ServiceDeskPlus-MSP>\jre
      For Linux
      open scp-sdpmsp-mssql-commandline.sh
      replace
      javahome=/home/test/ManageEngine/ServiceDeskPlus-MSP/jre/
      with
      javahome=<ServiceDeskPlus-MSP>/jre/
    5. Now run the scp-sdpmsp-mssql-commandline.bat/sh file present under the
      <Extracted-zip-folder>/DataMigration6.0/projects/scp-sdpmsp-mssql/

 

Once the above steps were completed please goto step 5 :

4) If you are using MySQL server follow the below steps :

  1. If SupportCenter Plus and ServiceDesk Plus - MSP installed in the same server
  1. Shutdown the SupportCenter Plus Server.
  2. Goto <SupportCenterPlus_Home>\bin directory.
  3. Execute - startdb.bat/sh(in case of linux) 33356
  4. Start the ServiceDeskPlus-MSP server once and login using the user interface to make sure the server has started.
  5. Shutdown the ServiceDeskPlus-MSP Server.
  6. Go to <ServiceDeskPlus-MSP_Home>\bin directory.
  7. Run startdb.bat.
  8. Go to <extractedfolder>/DataMigration 6.0/projects/scp-sdpmsp-mysq/
    For windows
    open scp-sdpmsp-mysql-commandline.bat
    replace
    set javahome=c:\ManageEngine\ServiceDeskPlus-Msp\jre
    with
    set javahome=<ServiceDeskPlus-MSP>\jre
    For Linux
    open scp-sdpmsp-mysql-commandline.sh
    replace
    javahome=/home/test/ManageEngine/ServiceDeskPlus-MSP/jre/
    with
    javahome=<ServiceDeskPlus-MSP>/jre/
  9. Run the scp-sdpmsp-mysq-commandline.bat/sh file present under the <extractedfolder>/DataMigration6.0/projects/sdp-msp-MySQL/
  10. Go to <ServiceDeskPlus_Home>\bin directory.
  11. Run stopdb.bat/sh 33356
  12. Go to <ServiceDeskPlus-MSP_Home>\bin directory
  13. Run stopdb.bat/sh

 

Once the above steps were completed please goto step 5

b) If SupportCenter Plus and ServiceDeskPlus MSP installed in different Servers.

  1. Shutdown the SupportCenter Plus Server.
  2. Goto <SupportCenterPlus_Home>\bin directory.
  3. Execute - startdb.bat/sh(in case of linux) 33356
  4. Goto <SupportCenterPlus_Home>\MySQL\bin directory
  5. Connect to the MySQL prompt by
    For windows
    Run MySQL -u root -P 33356
    For Linux
    Run MySQL -u root -S ../MySQL/tmp/MySQL.sock
  6. Run grant ALL on *.* to 'root'@'<ServiceDeskPlus - MSP installed host name>';
    for ex: grant ALL on *.* to 'root'@'servicedesk-test1';
    where netflow-test1 is the name of the server where ServiceDesk is installed.
  7. Now open the scp-sdpmsp-mysql.connection file
    present under <extracted folder>\DataMigration6.0\Projects\scp-sdpmsp-mysql
    replace
    SrcURL=jdbc\:MySQL\://localhost\:33356/supportcenter?useStreamLengthsInPrepStmts\=false
    with
    SrcURL=jdbc\:MySQL\://<SupportCenter hostname>\:33356/supportcenter?useStreamLengthsInPrepStmts\=false
    For ex:
    If SupportCenter is installed in a machine with hostname say supportcenter-test then
    SrcURL=jdbc\:MySQL\://supportcenter-test\:33356/servicedesk?useStreamLengthsInPrepStmts\=false
  8. Start the ServiceDeskPlus-MSP server once and
    login using the user interface to make sure the server has started.
  9. Shutdown the ServiceDeskPlus-MSP Server.
  10. Go to <ServiceDeskPlus-MSP_Home>\bin directory.
  11. Run startdb.bat.
  12. Go to <extractedfolder>/DataMigration 6.0/projects/scp-sdpmsp-mysql/
    For windows
    open scp-sdpmsp-mysql-commandline.bat
    replace
    set javahome=c:\ManageEngine\ServiceDeskPlus-Msp\jre
    with
    set javahome=<ServiceDeskPlus-MSP>\jre
    For Linux
    open scp-sdpmsp-mysql-commandline.sh
    replace
    javahome=/home/test/ManageEngine/ServiceDeskPlus-MSP/jre/
    with
    javahome= <ServiceDeskPlus-MSP>/jre/
  13. Run the scp-sdpmsp-mysql-commandline.bat/sh file present under the
    <extractedfolder>/DataMigration6.0/projects/sdp-msp-MySQL/
  14. Go to <SupportCenterPlus_Home>\bin directory.
  15. Run stopdb.bat/sh 33356
  16. Go to <ServiceDeskPlus-MSP_Home>\bin directory
  17. Run stopdb.bat/sh

 

Once the above steps were completed please goto step 5

5) After the execution of the batch file.
Copy the following folders inlineimages, fileattachments from the SupportCenter Plus home directory and replace it under the ServiceDeskPlus-MSP Home directory.

Now Start the ServiceDesk Plus - MSP server and login using the username and password as "administrator" and "administrator" respectively .

Note:If you have queries regarding migration send an email to . We will be glad to assist you.

Go to Top

 
展开