TABLE OF CONTENTS

Introduction

Some situations require creating a new local database on terminals be it PCA or MDA. For example sometimes terminals become slow if the local database has grown too large, and the quickest way to see if its the local database that's causing slowness or not would be to create a new local database.

Important thing to note about local databases

Local databases hold registrations that are done on that specific terminal. All this data does sync with the main database, meaning information is not getting lost when creating new local database. However if you create new local database, you will not see transactions done previously on this terminal on that new local database, they would reside on the old database. That's because old database would've been used at the time of making those registrations (transactions). So for example if customer creates a new local db, and then needs to reprint a label for a transaction made before switching to new local database, in that scenario customer will need to change the local database to the old one where the registration for that transaction was done. To do that just use the local database name to what it was previously (more on that below).

The bottom line is, whatever local database you use to make registrations on - that's where those transactions are going to be stored in case you need to access them from the terminal.

How to create new local database on PCA

1. Open connection profile

  • Run the application.
  • As soon as you start running the application, hold CTRL button untill connection profile window pops up.
  • Example of this on PCA is depicted on screenshot below.

2. Rename the local database name

  • On the screenshot above, you can see the local database name field highlighted in red.
    There the local database name is - iWAMS_DMS_RKB_EMYDEX_INTACT_LIVE
  • Rename the local database to a unique name.
    If the local db file with the name you specify in Connection Profile does not exist, then the PCA will create a new local db.
    If the local db file with the name you specify does exist, then it will use that local db file.
  • To make sure DB name is unique, you could rename it to include today's date in the name.
    Eg. New local db name could be - iWAMS_DMS_RKB_EMYDEX_INTACT_LIVE_202307417

3. Save changes and open up PCA

  • On the same screenshot you can see the "Save" button.
  • Press that, proceed opening the PCA.
  • You should be now using the new database.



How to create new local database on MDA

Very similar to PCA, just with couple extra clicks.

1. Open connection profile

  • Run the application.
  • As soon as you start running the application, hold CTRL button untill connection profile window pops up.
  • Example of this on MDA is depicted on screenshot below.

2. Rename the local database name

  • Once connection profiles window is opened, click on the connection profile to select which one you want to edit. (Number 1)
  • Click on Pencil icon to edit. (Number 2)
  • Edit the database name. (Number 3)
  • On the screenshot above, you can see the local database name field highlighted in red.
    There the local database name is - MDA_FORRESTERS_.SQLite
  • Rename the local database to a unique name.
    If the local db file with the name you specify in Connection Profile does not exist, then the PCA will create a new local db.
    If the local db file with the name you specify does exist, then it will use that local db file.
  • To make sure DB name is unique, you could rename it to include today's date in the name.
    Eg. New local db name could be -MDA_FORRESTERS_.SQLite_202307417

3. Save changes and open up MDA

  • On the same screenshot you can see the floppy disk icon, press that to Save the changes. (Number 4)
  • Double click on the connection profile name to start the MDA application. (Number 5)
  • You should be now using the new database.