Help & Resource Center

Migrating Modern Retail Counterpoint Integrator

To migrate the Integrator to a new server, you will need access to the old server and the new server.

Here are the steps required:

Old Server
1) On the old server, right-click on the Modern Retail desktop icon and select "Open file location". The default installation directory is: "C:\Program Files (x86)\Modern Retail Integrator"
2) In the old server installation directory, make a copy of the file named "MRCPISetup.xml". This file contains the application's configuration settings and will be needed for the new server.
3) In the old server installation directory, locate an executable file named "unins000.exe" and run the file. This will uninstall the Integrator from the old server.

New Server
4) Download the latest version of the Integrator from the following URL:
5) On the new server, run the file MRCPISetup.exe to install the Modern Retail Counterpoint Integrator.
6) Once the Integrator is installed on new server, right-click on the Modern Retail desktop icon and select "Open file location". to open the installation directory.
7) Copy the filename "MRCPISetup.xml" taken from the old server into the new server installation directory.

The modern Retail Counterpoint Integrator uses an MSSQL database called "MRCPI". It is usually not important to migrate the database to the new MSSQL server, as the database can simply be re-created from the Integrator MAIN MENU->Setup->Create MRCPI Database. The "Create MRCPI Database" menu option will be displayed if the Integrator cannot find its database. The database should only be migrated if the customer is using B2B application feature.

Additionally, If the new server Integrator will use a MSSQL server SHARED environment the database name of "MRCPI" can potentially conflict with other Modern Retail customers. In this case the MRCPI database name must be renamed in the MRCPISetup.xml file. If the default database name must be re-named, edit the MRCPISetup.xml file in an XML editor. Search for an xml node name "catalogname" ( <catalogname>MRCPI</catalogname>) and edit the value to MRCPI_XXXX. The idea is for the value of xml node "catalogname" to contain a database name that can associated to a specific customer. If the customer integration is not operating in a SHARED MSSQL environment, then you do not have to worry about changing the value of xml node "catalogname".

8) On the new server, run the Modern Retail Counterpoint Integrator from the desktop icon.
9) Once the Integrator opens, from the Main Menu, select Setup->CP Database Source. In the "CP Database Source" window, enter the new MSSQL database credentials. Use the "Test" button to test the credentials and save.

The MSSQL User used by the Integrator must have dbcreator permissions and must also have dbreader and dbwriter permission on the Counterpoint database.

10) Once the "CP Database Source" has been tested, select "Setup" from the Main Menu, wait a few moments and you should see the "Create MRCPI Database" menu option. Select "Create MRCPI Database" and create database.
11) Close the Modern Retail Counterpoint Integrator and run the program again. From the Main Menu, select "Log". If you see a few records in the Log, this tells use the MRCPI Database was successfully created.
12) From the Main Menu, Select Services->Start. This will start 3 windows services. The status of 2 of the Windows services will be displayed in the application status bar at the bottom of the window. Both services should display "Running".

If the services do not successfully start, close the application and “Run as Administrator”, then try to start the services again.

13) You can now close and exit the Modern Retail Counterpoint Integrator. The migration is complete.