For the complete documentation index, see llms.txt. This page is also available as Markdown.
configurationoffline databasestore databaseStore Administratorrmhdb.bckSQL ServerZ Report

Configure the offline database

This topic describes how to configure the offline database.

  1. (Recommended) Install Microsoft SQL Server Express on the same computer as POS.

  2. Attach the empty offline database rmhdb.bck. The offline database is usually available under C:\Program Files (x86)\Retail Hero\RMH Store Manager\DBFiles.

  3. Start Store Administrator on the computer where POS is installed. The shortcut should be available on the desktop.

  4. Click Configuration.

  5. Click the Offline tab.

  6. In the Server Name field, type the host name of the computer where you installed SQL Server Express, a backwards slash, and the name of the SQL Server instance.

If you installed SQL Server Express on the same computer as POS, you can use a period, (local), or localhost for the host name. The SQL Server instance cannot be the same as the SQL Server instance for the store database.

  1. In the Database field, type the name of the empty offline database.

  1. Select Use SQL Server Authentication.

  2. Enter the User name and Password.

  3. Click Test Database Connection. You should see the message Database successfully connected.

  4. Click Save And Close.

  5. Open POS.

  6. Print the Z Report to close the batch at the register. The Z Report synchronizes data from the store database to the offline database, and vice versa.

Last updated