Skip to main content
Barracuda MSP Partner Toolkit

How to Migrate an Onsite Manager

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. Please read this How-To end to end to ensure you understand the process and reach out to Support if you are stuck.

NOTE: Using the Onsite Manager installer downloaded from the Service Center is not supported. You will need the full installer from the partner portal 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

On the new OM device, download either SQL Server Express 2014 or 2016. The following steps are specific to each deployment but will work if followed exactly. Select either Option a or Option b to continue.

Option a) Steps for setting up SQL Server 2014 Express
  • Download SQL Server 2014 Express 
  • Select the 64-bit installer
  • Download to a C:\Temp folder
  • Open a Command Prompt as Administrator
  • Enter in the following command:
C:\Temp\SQLEXPR_x64_ENU.exe -x:C:\SQLServer
  • Once this completes, enter the following command in same Command Prompt 
C:\SQLServer\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 2014 Express and create the SQL Instance required to migrate your On-Site Manager.


Option b) Steps for setting up SQL Server 2016 Express
C:\Temp\SQLServer2016-SSEI-Expr -x:C:\SQLServer 
  • Select Basic Install
  • Once this completes, enter the following command in same Command Prompt 
C:\SQLServer2016Media\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 2016 Express and create the SQL Instance required to migrate your On-Site Manager.


Performing the SQL Database Back-up
  • Uninstall your Onsite Manager from the old device
  • Load SSMS and expand your LPIMWOMEXPRESS instance
  • Expand Databases
  • Right-click on MWData
  • Select Tasks
  • Select Backup
  • Add a disk destination and back up the database

Restore the MWData database
  • Transfer that backup up to the new OM device and save it to C:\Temp
  • Open SSMS on the new OM
  • Expand LPIMWOMEXPRESS
  • Right Click on Databases
  • Select Restore Database
  • Target the MWData backup in C:\Temp
  • Set the Compatibility of the database under Properties -> Options is set to at least 2014 (2016 if you did Step 2b)

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
  • Download the Onsite Manager package from Barracuda Campus
    • If you cannot log into the Partner Portal, please call support
  • Unblock the package, Unzip and run SetupOM as administrator
  • Continue through the installation and when prompted enter the public SCMessaging URL found in your service center under Configuration-> System Settings-> Communication Settings

  • Was this article helpful?