Relocating BxLogistics - BxEngine and BxSmartPrintPro

How to relocate the BxLogistics services BxEngine og BxSmartPrintPro

There are three different ways in which you can relocate BxEngine:
BxEngine service
BxEngine service and BxEngine database
BxEngine database
All three requires certain adjustments in different setups. But you always install with the latest available version of BxEngine, downloaded from the partner portal.

For BxSmartPrintPro there's only one way to relocate it. But here as well, you always install with the latest version of BxSmartPrintPro, downloaded from the partner portal. 

To get a validated license after it has been relocated you need to notify us on support@bxsoftware.no so that we can unlock them, as they are by default locked to the last server they were validated on. You must end and deactivate all services of BxEngine and/or BxSmartPrintProService in Windows Services before we can free up the licenses.

Table of contents

  1. BxEngine
    1. BxEngine service
    2. BxEngine database
  2. BxSmartPrintPro

BxEngine

a. BxEngine service

This section addresses the relocation of the BxEngine service only. This typically occurs when the application server is changed, but the SQL server is not.
To relocate the BxEngine service, you need to end and deactivate the BxEngine service within Windows Services on the old server.

Download BxEngine from partner.bxsoftware.no/home - Downloads can be found in the upper right corner. Contact support@bxsoftware.no if you don't have access to the partner portal. Download BxEngine for BxLogistics/BxSales/BxStockCount.
image-png-Oct-28-2022-10-55-11-7110-AM.png (276×248) image-png-Oct-28-2022-10-57-20-5764-AM.png (569×269)
Install BxEngine on the new server by running the msi file, then follow and finish the installation dialogue.

When BxEngine has finished installing, start the BxEngine Monitor. Be patient and wait for the Setup box to pop up (it may on some occasions take a bit of time before it pops up). Enter the license key, SQL server name, the BxEngine database + username and password into the Setup box. Press Confirm and wait until you see the "License validated OK" message comes up. Press OK and wait approx. 1 minute before you restart the BxEngine service. Once the BxEngine service has been restarted, it should function normally. 

bxloginstdel1bxeng7.png (406×211) image-png-4.png (151×135)

bxloginstdel1bxeng10.png (496×232)
 

b. BxEngine database

There are more ways than one to relocate a database, and here we address how to backup the database on the old server + restoration of the database on the new one. This can be combined with the relocation of the BxEngine service as long as both app and SQL server is changed. 

Open SQL Server Management Studio -> Right click on the BxEngine database -> Tasks -> Back Up...

In the Backup dialogue you get the option to press OK to immediately run the backup. If you do, make sure to take notice of the file path the backup is stored on. In this case we are removing the existing destination and locating our own as C:\Temp\BxEngine.bak. Then press OK to start the backup process. Once the backup process is finished, you can transfer the BxEngine.bak file to a new SQL server. 


When the BxEngine.bak file has been transferred to a new server, run a restoration of the database. Right click on Databases -> Restore Database -> Choose Device -> ... -> Add -> Locate the backup file -> OK -> OK. 

Make sure that Backup sets to restore looks correct under General. Under Files, make sure to turn on the Relocate all files to folder and make sure all the paths looks correct. Then press OK to restore backup. The next step will be to delete the user from the database, and then set it up again. 


When this is all done, delete the BxEngine user from the database, and set up the user again with the same parameters as before. 

After the user has been deleted and recreated, you can do the neccessary setup with BxEngine. When relocating the BxEngine service simultaneosly as the database see point a. BxEngine Service

If the existing BxEngine installation is being updated, you must delete (or edit) the BxEngine.ini file that you find under C:\ProgramData\BxSoftware\BxEngine\Config, and then start the BxEngine Monitor (ref. point a) and add license key + SQL details, Confirm -> OK. Wait until Service has started, then restart the service.
bxloginstdel1bxeng7.png (406×211) image-png-4.png (151×135)
bxloginstdel1bxeng10.png (496×232)

The last step will be to edit the SQL connection within BxAdmin. Log into BxAdmin, open Installation and double click the field below Database connections that is being edited and then enter/update to save. 
Once this has all been completed, everything should function normally and as expected. Test queries under SQL Integration to get confirmation. 

BxSmartPrintPro

Relocating BxSmartPrintPro is relatively easy. To relocate a BxSmartPrintPro installation, you first need to end and deactivate the BxSmartPrintProService service on the old server. Then let us know by sending a message to support@bxsoftware.no so that we can release the licenses. BxSmartPrintPro can then be installed normally like this: Installation BxSmartPrintPro

Next step will be to install the same print queues used with BxSPP from the old server, onto the new server. We recommend that you install the print queues with the same names as before, as you won't have to edit/add these again later in BxSmartPrintPro.

Close BxSmartPrintPro before the configuration is copied over.Files will be copied over to the same catalogue on the new server. Settings and label templates can be found under C:\ProgramData\BxSoftware\BxSmartPrintPro\Config -> Companies.ini and PrinterFiles.ini - The files contain settings i BxSmartPrintPro and the various printers connected to "company" in BxSPP.
In the C:\ProgramData\BxSoftware\BxSmartPrintPro\Config\Labels folder, you will find one or more json filer, and these are the label templates.
If the label templates consists of one or more photos/logos, make sure to copy these over to the new server as well, to the same catalogue as before. Make adjustments, if necessary, to the file path in the template setup if this has been changed.

Start/restart the BxSmartPrintPro service after full run through and completion of the abovementioned steps. It will now function normally.