Search our knowledgebase

Moving your Lansweeper installation to a different server

Last updated on September 06 2017

If required, you can move your Lansweeper installation from one computer to another. The exact migration procedure you should follow depends on which database server you are using, SQL Compact or SQL Server. If you are unsure which database server you are using, browse to the following section of the web console: Configuration\Your Lansweeper License

checking used database server

Moving your installation if you are using SQL Compact

To move your installation to another computer if your database server is SQL Compact, do the following:

  1. Create a full backup of your Lansweeper installation by following the steps in this knowledge base article.
  2. Perform an Easy install of Lansweeper on the computer you want to migrate to. Installation instructions can be found in this knowledge base article.
    performing an Easy Install
  3. Restore your backup over the new Lansweeper installation by following the steps in this knowledge base article.
  4. If necessary, update the Action Path in the Configuration\Asset Pages section of the web console, replacing the old computer name in the path with the new one. Your Action Path determines where Lansweeper will try to locate scripts and executables used by asset and user actions.
    Asset Pages menu

Moving your installation if you are using SQL Server

To move your installation to another computer if your database server is SQL Server, do the following:

  1. Create a full backup of your Lansweeper installation by following the steps in this knowledge base article.
  2. Perform an Advanced install of Lansweeper on the computer you want to migrate to and select SQL Server as your database server. Installation instructions can be found in this knowledge base article.
    performing an Advanced Install
  3. Restore your backup over the new Lansweeper installation by following the steps in this knowledge base article.
  4. If necessary, update the Action Path in the Configuration\Asset Pages section of the web console, replacing the old computer name in the path with the new one. Your Action Path determines where Lansweeper will try to locate scripts and executables used by asset and user actions.
    Asset Pages menu
  5. If your Lansweeper license allows for multiple scanning servers and the scanning configuration of the old scanning server should be migrated to the new scanning server, run the following tool on the new server:
    Program Files (x86)\Lansweeper\Tools\DatabaseMaintenance.exe
    running the Lansweeper Database Maintenance tool
  6. If your Lansweeper license allows for multiple scanning servers and the scanning configuration of the old scanning server should be migrated to the new scanning server, execute the script below in the Script Execution tab of the aforementioned tool. You'll need to replace OldServer with the NetBIOS name of the old scanning server and NewServer with the NetBIOS name of the new scanning server, leaving the single quotes in place. The script deletes the new, empty tab that will have been generated for the new scanning server under Scanning\Scanning Targets in the web console and transfers the old scanning server settings to the new server.
    delete from tsysasservers where servername = 'NewServer'
    GO
    update tsysasservers set servername = 'NewServer' where servername = 'OldServer'
    GO
    update tblassets set scanserver = 'NewServer' where scanserver = 'OldServer'
    GO
  7. Restart the Lansweeper Server service in Windows Services