ANSWER ID:9423For security reasons RetailManager will not allow you to upgrade your database over the network. This support note provides a step by step process on the best way to upgrade your RetailManager Database database when it is 's stored on a networked machine or dedicated Serverserver.Note: Before beginning, ensure you have already installed UI Text Box |
---|
| Before you begin Ensure you have installed the latest version of RetailManager on the | software on the computer you want to use to upgrade the database. |
Initial setup Before we can upgrade the database, we must create UI Expand |
---|
title | 1. Create a new folder |
---|
| Before upgrading the database, you need to create a folder on the computer where RetailManager is installed. Create a new folder on the local hard drive.
| Open Windows Explorer by right-clicking the Windows Start button and choosing Explore.- 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.
- Double-click Local Disk (typically the "C:" drive).
- 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.
- Name the new folder RMUPGRADE.
Open RetailManager on any machine on the network. - Go to the File menu and choose Configuration.
- Take a note of the database path for each of your databases.
| Backup UI Expand |
---|
title | 2. Back up your database |
---|
| The next step is to | backup back up your database to a machine that has RetailManager installed. Open RetailManager and open your shopfront. Go to the File menu and choose Configuration. Click Yes to close your shopfront. Click to highlight your database then click the Maintenance tab. In the Save As window, save the file into the folder created earlier, for example C:\RMUPGRADE. See our example below.
Image Modified Click OK to the message confirming the backup completion.
| Restoring UI Expand |
---|
title | 3. Restore your database |
---|
| Now that we have made a backup of the database from the server, we are now You're now ready to restore | this the backup to a machine that has RetailManager. From the Configuration window, click Restore. 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.
Image Modified When the following window is displayed, select the option Create a new shopfront using restored data. This will create a new Shopfront.
Image Modified If you have a look in your Shopfront Selection window, you will have a new Shopfront present as shown in the following example.
Image Modified Close the Configuration window. In the next window select the Restored_RMxxxxxx Shopfront.
| Upgrading UI Expand |
---|
title | 4. Upgrade your database |
---|
| At this stage | we have our database your database on the same machine that RetailManager is installed on. | Now we are You're now ready to upgrade the database. - Open RetailManager and open the database Restored_RMXXXXX.
- Click Yes to upgrade your database.
Image Modified
| Moving your
UI Expand |
---|
title | 4. Move the upgraded database to the server |
---|
| Once your database has been upgraded | we can now move your database back you can move it back to the server machine. | Backing This is done by backing up the database then restoring it on your server. To back up your database- Go to the File menu and choose Configuration.
Click Yes to close your shopfront. Highlight the Restored_XXXX database and click the Maintenance tab. Click Backup. Change the file name to RMUpgraded and save it in the RMUpgrade folder created earlier. Click OK to the backup confirmation, then click the Shopfront tab. Since we no longer need the Restored_xxxx database, remove it by highlighting it and
| selecting the disconnect button Restoring the upgraded database to your To restore the database on the server- Go to the File menu and choose Configuration.
- Click Yes to close your shopfront.
Click the Maintenance tab. Click Restore. Select the option Restore your shopfront to a new folder then click OK. - In the Save As window, save the file in the location you took note
| at the start - of earlier in this support note
| (see step 4 of Initial setup)- . This will ask to overwrite the existing database. Click Yes.
You will now be able to run the new version on all machines.
|
|