2.2.7. Database Upgrading from SambaPOS V3 and/or V4 to V5
SambaPOS V5 Pro, supports database upgrading automatically from SambaPOS V3 and SambaPOS V4 versions.
Before starting this process you should definitely take backup of database to another digital place (Usb flash disk, cd or another computer)
It’s possible to upgrade from V3 to V5 directly. We recommend you to perform this process, upgrading step by step. First transfer V3 data into V4 version and then transfer V4 data into V5 Pro.
Automatic Upgrading from Version V3 to Version V4
After backing up used database, according to warnings above, download SambaPOS 4.1.82.exe setup file from https://sambapos.com/download/
After installing a standard V4 on a computer login to V4. If V3 is still running on computer it has to be stopped.
After running V4 Manage > Local Settings > Database Connection in this section type exact same database connection address which being used for version 3 and add to the end Database=SambaPOS3;
In the example Database connection settings for SamabPOS V3 is like below;
Edit database connection on SambaPOS V4 like shown below, click on Save button and close the SambaPOS.
data source=ISTANBUL; user id=sa; password=samba.1234; Database=SambaPOS3;
After writing Database Connection, close the SambaPOS and run again SambaPOS 4.1.82.exe file which already downloaded on computer and install over it.
Note: This setup will give information about database has been changed and V4 needs to update database according to itself. This is why don’t run SambaPOS after writing Database Connection and log off then install over it again.
After writing and installing over it SambaPOS V4 database connection, run the program. So that database file has been transferred from V3 to SambaPOSV4.
Automatic Upgrading from V4 Version to V5 Pro
Download and install latest version of SambaPOS V5 Pro from here https://sambapos.com/download/ After running the SambaPOS, on the navigation screen go to Manage > Settings > Local Settings and click on Database tab.
In here click on Edit Connection button. Make this field possible for writing and type the exact same sentence which existing in SambaPOS V4.
Click on Save button. Just like previous step run SambaPOS V5 by installing over it again.
After installing again SambaPOS V5 Pro run it. On the navigation screen enter Manage > Settings > Program Settings > Maintenance > Upgrade Old Rules click on this menu so that old rules will be updated according to latest version.
A dialogue box will appear which saying that how many rules have been upgraded depending on using old SambaPOS V3 or SambaPOS V4.
So that data transfer is completed.
Updating Database Indexes
During the data transfers for new versions, recreating Database indexes is essentially important. So that SambaPOS can provide reports fastly and works fastly.
To create indexes go to Manage > Local Settings > Program Settings in this menu click on edit section in Currency Decimals tab.
In the window change Database Decimal Places field from 2 to 3 and click on Save button. After clicking on Save button (it might take few minutes depending on size of database) SambaPOS comes back to password screen.
Type password start again and perform same steps and change back the value from 3 to 2 which is original value. Database will be ready once you restart SambaPOS after logging it off completely.