Migrating LYNQ (Apps and Data) to another server

Further Information
Contact our support team support@lynqmes.com or raise a support case from the Support Portal.

A common question asked by our user base is how can we migrate LYNQ (applications and data) to another server(s). As there is no easy way to migrate the application files from one server to another server, you will need to re-install LYNQ mom and LYNQ api on the new Web Server.  In addition, if you are hosting Visual APS on an application server, Visual APS must also be re-installed.  Before starting the migration steps below, make a note of the versions that are currently installed. The same version or a higher version will need to be selected in the Product Updater when re-installing.  To successfully migrate LYNQ to other servers, complete the steps below.
 

To check which version of Visual APS is installed:

1. Open Visual APS on a working computer
2. Select About
3. Make a note of the build number installed.

To check which version of LYNQ mom is installed:

1. Open LYNQ mom
2. Select Help
3. Make a note of the build number installed.

To check which version of LYNQ api is installed:

1. Open LYNQ api
2. Select Settings
3. Select Licensing
4. Make a note of the build number installed.

Step 1 Backup and Restore the SQL Databases

1. Take full backups of all databases that form part of LYNQ 
   1. ERP Database
   2. MOM Data
   3. MOM Data Live Statistics
   4. MOM Config
   5. MOM Logic
   6. MOM FA
   7. LYNQ api
2. Restore backups of all databases to the new SQL Server
    

Step 2 Re-create the SQL User for LYNQ and any APS SQL users

1. Create a new SQL user and password on the new SQL Server
   1. Open the SQL Management Studio
   2. Right Click on the Security Folder
   3. Select New
   4. Select Login
   5. Select the SQL Server Authentication Option
   6. Enter a Login Name
   7. Enter a Password
   8. Select the User Mapping Settings
   9. Select each database used by LYNQ and assign the db_owner database role
      1. ERP database(s)
      2. MOM Data database
      3. MOM Data Live database
      4. MOM Config database
      5. MOM Logic database
      6. MOM FA database
      7. LYNQ api database
   10. Select OK
   11. If you receive an error that the SQL user already exists, you should delete the SQL User from the database first.
       1. Select Databases
       2. Select the Database (i.e. ERP Database, repeat for all LYNQ databases)
       3. Select Security
       4. Select Users
       5. Right click on the SQL User you are trying to re-create and select delete
2. Create SQL Windows Users/Groups or SQL Users for the APS users on the new SQL Server
   1. If APS users were connecting to the ERP database using the app role (see database connections in APS), you only need to add a user mapping for the public role for each user/group and ERP database. 
   2. Alternatively assign explicit permissions as db_owner for each APS user or group.
       

Step 3 Re-install the LYNQ applications

1. On the new Web Server load the Product Updater
2. Complete a new installation of LYNQ mom (select the same build numbers or higher)
   1. Specify the following details in the configurator screen:
      1. SQL Server Name
      2. Database Names (enter the restored database names)
      3. SQL User and SQL Password details (new user details created in step 2)
      4. Administrator Names
3. Complete a new installation of LYNQ api (select the same build numbers or higher)
   1. Specify the following details in the configurator screen:
      1. SQL Server Name
      2. LYNQ api Database Name (enter the restored database name)
      3. SQL User and SQL Password details (new user details created in step 2)
      4. Administrator Names
4. Complete a new installation of LYNQ aps (application servers only)

Step 4 Update LYNQ settings which store SQL Server/Database Names

Some settings within LYNQ store the SQL Server and SQL Database Names.  These settings should be updated to reflect the migrated installation

1. Create new a Database Connection in Visual APS to open the company on the new SQL Server (complete on all APS Clients)
2. Within Visual APS select File > Company Settings > Settings > Integration
   1. Change the MOM integration URL to the new server (only complete this once, this setting is stored within the ERP database)
3. Within LYNQ mom select Settings 
   1. Specify the correct host name in the LYNQ api settings section
   2. Click on Test
   3. Select the correct Instance
   4. Select Save
4. Within LYNQ api select Instance Settings
   1. Edit each API instance and update
      1. Server 
      2. User ID (created in Step 2)
      3. Password (created in Step 2)
      4. Database (this should be the ERP database
5. Within LYNQ api open each instance and update the API Settings
   1. Check that any service URL's are specified correctly and update if the ERP api has been installed to a different server
   2. Under MOM Settings update
      1. Server
      2. User ID (created in Step 2)
      3. Password (created in Step 2)
      4. MOM Data Database (restored database name)

Once all 4 steps have been completed, LYNQ will be migrated and ready for use.