It seems like your browser didn't download the required fonts. Please revise your security settings and try again.
Barracuda MSP Knowledgebase

How to Migrate an Onsite Manager

  • Last updated on

Moving an Onsite Manager is an intensive and hands-on process. This guide will walk you through how to prepare and execute a proper migration to a new device within your environment. Read this How-To end to end to ensure you understand the process and reach out to Support if you are stuck.

Using the Onsite Manager installer downloaded from the Service Center is not supported. You will need the full installer from Barracuda Campus to proceed. Please see below.  

Preparing for the Migration


Before you begin, you will want to ensure that the Onsite Manager is fully up to date this can be checked in the Service Center > Update Center > Products. The following steps will assume you have updated the OM to the last release.

On both the existing OM and the new OM device, download and install SQL Server Management Studio (SSMS)

Installing SQL Server Express and Setting up the Instance


Follow the below steps on how to prepare a new device for the SQL Instance, Database Migration and the OM installation.

Steps for setting up SQL Server 2017 Express on the NEW Onsite Manager Device
  1. Download SQL Server 2017 Express.
  2. Move the SQLServer2017-SSEI-Expr.exe file into C:\Temp folder.
  3. Open a Command Prompt as Administrator.
  4. Run the following command: C:\Temp\SQLServer2017-SSEI-Expr -x:C:\SQLServer
  5. Select Basic Install.
  6. Accept the Microsoft SQL Server License Terms
  7. Select Install on the location screen, the download and installation process will begin
  8. Once at the successful installation screen, click Close
  9. Enter the following command in same Command Prompt:
    C:\SQLServer2017Media\Express_ENU\setup.exe ^
    /QS ^
    /ACTION=Install ^
    /FEATURES=SQLEngine ^
    /IAcceptSQLServerLicenseTerms=true ^
    /SECURITYMODE=SQL ^
    /SQLSVCSTARTUPTYPE=Automatic ^
    /ADDCURRENTUSERASSQLADMIN=true ^
    /TCPENABLED=1 ^
    /NPENABLED=1 ^
    /ENU ^
    /INSTANCENAME=LPIMWOMEXPRESS ^
    /SQLSVCACCOUNT="NT AUTHORITY\SYSTEM" ^
    /SAPWD=#StrongExpress1 ^
    /SQLSYSADMINACCOUNTS="BUILTIN\Administrators" ^
    /INSTANCEDIR="C:\Program Files\Microsoft SQL Server"

This will install SQL Server 2017 Express and create the SQL Instance required to migrate your On-Site Manager.


Performing the SQL Database Back-up

  1. Uninstall your Onsite Manager from the old device.
  2. Load SSMS and expand your LPIMWOMEXPRESS instance.
  3. Expand Databases.
  4. Right-click on MWData.
  5. Select Tasks.
  6. Select Backup.
  7. Add a disk destination and back up the database.

Restore the MWData database

  1. Transfer that backup up to the new OM device and save it to C:\Temp.
  2. Open SSMS on the new OM.
  3. Expand LPIMWOMEXPRESS.
  4. Right-click Databases.
  5. Select Restore Database.
  6. Target the MWData backup in C:\Temp.
  7. Set the Compatibility of the database under Properties > Options is set to the latest version available.
In the event that you cannot get access to the device, but have access to the overall files, browse to C:\Program Files\Microsoft SQL Server\MSSQL13.LPIMWOMEXPRESS\MSSQL\DATA folder and grab the MWData.mdf and MWData_Log.ldf files to attach (similar to the steps as above, but attach rather than restore).
Install the On-Site Manager and Complete the Migration

  1. Download the Onsite Manager package from Barracuda Campus.
  2. Unblock the package, unzip and run SetupOM as administrator.
    1. Support recommends that as you installed SSMS already, run Advanced Installer and unselect SQL Tools
  3. Continue through the installation and when prompted enter the public SCMessaging URL found in your service center under Configuration > System Settings > Communication Settings.
Additional Information

Last updated on