Before upgrading the database, you need to create a folder on the computer where RetailManager is installed.

1. Create a new folder on the local hard drive.
   1. Simultaneously press the Windows and E keys on the keyboard (the Windows key is between the Ctrl and Alt keys). The File Explorer window appears.
   2. Double-click Local Disk (typically the "C:" drive).
   3. In the right hand panel of the window (where the contents of the C: drive are displayed), right-click in an empty space and choose New then choose Folder.
   4. Name the new folder RMUPGRADE.
2. Open RetailManager on any machine on the network.
3. Go to the File menu and choose Configuration.
4. Take a note of the database path for each of your databases.

The next step is to back up your database to a machine that has RetailManager installed. 

1. Open RetailManager and open your shopfront.
2. Go to the File menu and choose Configuration.
3. Click Yes to close your shopfront.
4. Click to highlight your database then click the Maintenance tab.
5. In the Save As window, save the file into the folder created earlier, for example C:\RMUPGRADE. See our example below.
   
6. Click OK to the message confirming the backup completion.

You're now ready to restore the backup to a machine that has RetailManager.

1. From the Configuration window, click Restore.
2. In the Select file to restore window, find the backup we created earlier. It will be in the folder you selected when making the backup, for example C:\RMUPGRADE. See our example below.
   
3. When the following window is displayed, select the option Create a new shopfront using restored data. This will create a new Shopfront.
   
   If you have a look in your Shopfront Selection window, you will have a new Shopfront present as shown in the following example.
   
4. Close the Configuration window.
5. In the next window select the Restored_RMxxxxxx Shopfront.

At this stage you have a copy of your database on the same machine that RetailManager is installed on. You're now ready to upgrade the database.

1. Open RetailManager and open the database Restored_RMXXXXX.
2. Click Yes to upgrade your database.
    

Once your database has been upgraded you can move it back to the server machine. This is done by backing up the database then restoring it on your server.

To back up your database

1. Go to the File menu and choose Configuration.
2. Click Yes to close your shopfront.
3. Highlight the Restored_XXXX database and click the Maintenance tab.
4. Click Backup.
5. Change the file name to RMUpgraded and save it in the RMUpgrade folder created earlier.
6. Click OK to the backup confirmation, then click the Shopfront tab.
7. Since we no longer need the Restored_xxxx database, remove it by highlighting it and clicking Disconnect.

To restore the database on the server

1. Go to the File menu and choose Configuration.
2. Click Yes to close your shopfront.
3. Click the Maintenance tab.
4. Click Restore.
5. Select the option Restore your shopfront to a new folder then click OK.
6. In the Save As window, save the file in the location you took note of earlier in this support note.  This will ask to overwrite the existing database. Click Yes.
7. You will now be able to run the new version on all machines.