{"id":9495,"date":"2018-01-17T14:26:49","date_gmt":"2018-01-17T14:26:49","guid":{"rendered":"https:\/\/kb.sambapos.com\/?p=9495"},"modified":"2024-07-04T11:40:51","modified_gmt":"2024-07-04T11:40:51","slug":"2-2-7-database-upgrading-from-sambapos-v3-and-or-v4-to-v5","status":"publish","type":"post","link":"https:\/\/kb.sambapos.com\/en\/2-2-7-database-upgrading-from-sambapos-v3-and-or-v4-to-v5\/","title":{"rendered":"2.2.7. Database Upgrading from SambaPOS V3 and\/or V4 to V5"},"content":{"rendered":"<p>SambaPOS V5 Pro, supports database upgrading automatically from\u00a0SambaPOS V3 and SambaPOS V4\u00a0versions.<\/p>\n<p>Before starting this process you should definitely take backup of database to another digital place (Usb flash disk, cd or another computer)<\/p>\n<p>It&#8217;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.<\/p>\n<p>&nbsp;<\/p>\n<p><strong>Automatic Upgrading from Version V3 to Version V4\u00a0<\/strong><\/p>\n<p>After backing up used database, according to warnings above, download SambaPOS 4.1.82.exe setup file from <a href=\"https:\/\/sambapos.com\/download\/\">https:\/\/sambapos.com\/download\/<\/a><\/p>\n<p>After installing a standard V4 on a computer login to V4. If V3 is still running on computer it has to be stopped.<\/p>\n<p>After running V4\u00a0<strong>Manage &gt; Local Settings &gt; Database Connection <\/strong>in this section type exact same database connection address which being used for version 3 and add to the end\u00a0Database=SambaPOS3;<\/p>\n<p>In the example Database connection settings for SamabPOS V3 is like below;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-29914 size-full\" src=\"https:\/\/kb.sambapos.com\/wp-content\/uploads\/2018\/01\/1.jpg\" alt=\"\" width=\"640\" height=\"360\" srcset=\"https:\/\/kb.sambapos.com\/wp-content\/uploads\/2018\/01\/1.jpg 640w, https:\/\/kb.sambapos.com\/wp-content\/uploads\/2018\/01\/1-300x169.jpg 300w\" sizes=\"auto, (max-width: 640px) 100vw, 640px\" \/><\/p>\n<p>Edit database connection on SambaPOS V4 like shown below, click on Save button and close the SambaPOS.<\/p>\n<p>data source=ISTANBUL; user id=sa; password=samba.1234; Database=SambaPOS3;<\/p>\n<p>&nbsp;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-29916 size-full\" src=\"https:\/\/kb.sambapos.com\/wp-content\/uploads\/2018\/01\/2.jpg\" alt=\"\" width=\"640\" height=\"346\" srcset=\"https:\/\/kb.sambapos.com\/wp-content\/uploads\/2018\/01\/2.jpg 640w, https:\/\/kb.sambapos.com\/wp-content\/uploads\/2018\/01\/2-300x162.jpg 300w\" sizes=\"auto, (max-width: 640px) 100vw, 640px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>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.<\/p>\n<p>Note: This setup will give information about database has been changed and V4 needs to update database according to itself. This is why don&#8217;t run SambaPOS after writing Database Connection and log off then install over it again.<\/p>\n<p>After writing and installing over it SambaPOS V4 database connection, run the program. So that database file has been transferred from V3 to SambaPOSV4.<\/p>\n<p><strong>Automatic Upgrading from V4 Version to V5 Pro<\/strong><\/p>\n<p>After transferring the data into SambaPOS V4, do the same for V5 Pro.<\/p>\n<p>Download and install latest version of SambaPOS V5 Pro from here\u00a0<a href=\"https:\/\/sambapos.com\/download\/\">https:\/\/sambapos.com\/download\/<\/a>\u00a0After running the SambaPOS, on the navigation screen go to <strong>Manage &gt; Settings &gt; Local Settings<\/strong>\u00a0and click on <strong>Database<\/strong> tab.<\/p>\n<p>In here click on Edit Connection button. Make this field possible for writing and type\u00a0the exact same sentence which existing in SambaPOS V4.<\/p>\n<p>Click on Save button. Just like previous step run SambaPOS V5 by installing over it again.<\/p>\n<p>&nbsp;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-29918 size-full\" src=\"https:\/\/kb.sambapos.com\/wp-content\/uploads\/2018\/01\/3.jpg\" alt=\"\" width=\"640\" height=\"360\" srcset=\"https:\/\/kb.sambapos.com\/wp-content\/uploads\/2018\/01\/3.jpg 640w, https:\/\/kb.sambapos.com\/wp-content\/uploads\/2018\/01\/3-300x169.jpg 300w\" sizes=\"auto, (max-width: 640px) 100vw, 640px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>After installing again SambaPOS V5 Pro run it. On the navigation screen enter\u00a0<strong>Manage &gt; Settings &gt; Program Settings &gt; Maintenance &gt; Upgrade Old Rules <\/strong>click on this menu so that old rules will be updated according to latest version.<\/p>\n<p>&nbsp;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-29920 size-full\" src=\"https:\/\/kb.sambapos.com\/wp-content\/uploads\/2018\/01\/4.jpg\" alt=\"\" width=\"640\" height=\"360\" srcset=\"https:\/\/kb.sambapos.com\/wp-content\/uploads\/2018\/01\/4.jpg 640w, https:\/\/kb.sambapos.com\/wp-content\/uploads\/2018\/01\/4-300x169.jpg 300w\" sizes=\"auto, (max-width: 640px) 100vw, 640px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>A dialogue box will appear which saying that how many rules have been upgraded depending on using old SambaPOS V3 or SambaPOS V4.<\/p>\n<p>&nbsp;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-29922 size-full\" src=\"https:\/\/kb.sambapos.com\/wp-content\/uploads\/2018\/01\/5.jpg\" alt=\"\" width=\"640\" height=\"360\" srcset=\"https:\/\/kb.sambapos.com\/wp-content\/uploads\/2018\/01\/5.jpg 640w, https:\/\/kb.sambapos.com\/wp-content\/uploads\/2018\/01\/5-300x169.jpg 300w\" sizes=\"auto, (max-width: 640px) 100vw, 640px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>So that data transfer is completed.<\/p>\n<p><strong>Updating Database Indexes\u00a0<\/strong><\/p>\n<p>During the data transfers for new versions, recreating Database indexes is essentially important. So that SambaPOS can provide reports fastly and works fastly.<\/p>\n<p>To create indexes go to <strong>Manage &gt; Local Settings &gt; Program Settings<\/strong>\u00a0in this menu click on edit section in\u00a0<strong>Currency Decimals\u00a0<\/strong>tab.<\/p>\n<p>&nbsp;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-29924 size-full\" src=\"https:\/\/kb.sambapos.com\/wp-content\/uploads\/2018\/01\/6.jpg\" alt=\"\" width=\"640\" height=\"360\" srcset=\"https:\/\/kb.sambapos.com\/wp-content\/uploads\/2018\/01\/6.jpg 640w, https:\/\/kb.sambapos.com\/wp-content\/uploads\/2018\/01\/6-300x169.jpg 300w\" sizes=\"auto, (max-width: 640px) 100vw, 640px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-29926 size-full\" src=\"https:\/\/kb.sambapos.com\/wp-content\/uploads\/2018\/01\/7.jpg\" alt=\"\" width=\"640\" height=\"360\" srcset=\"https:\/\/kb.sambapos.com\/wp-content\/uploads\/2018\/01\/7.jpg 640w, https:\/\/kb.sambapos.com\/wp-content\/uploads\/2018\/01\/7-300x169.jpg 300w\" sizes=\"auto, (max-width: 640px) 100vw, 640px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>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.<\/p>\n<p>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.<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>SambaPOS V5 Pro, supports database upgrading automatically from\u00a0SambaPOS V3 and SambaPOS V4\u00a0versions. Before starting this process you should definitely take backup of database to another digital place (Usb flash disk, cd or another computer) It&#8217;s possible to upgrade from V3 to V5 directly. We recommend you to perform this process, upgrading step by step. First [&hellip;]<\/p>\n","protected":false},"author":11,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5,14],"tags":[],"class_list":["post-9495","post","type-post","status-publish","format-standard","hentry","category-installation","category-2-2-sambapos-basic-setup"],"_links":{"self":[{"href":"https:\/\/kb.sambapos.com\/en\/wp-json\/wp\/v2\/posts\/9495","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/kb.sambapos.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kb.sambapos.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kb.sambapos.com\/en\/wp-json\/wp\/v2\/users\/11"}],"replies":[{"embeddable":true,"href":"https:\/\/kb.sambapos.com\/en\/wp-json\/wp\/v2\/comments?post=9495"}],"version-history":[{"count":17,"href":"https:\/\/kb.sambapos.com\/en\/wp-json\/wp\/v2\/posts\/9495\/revisions"}],"predecessor-version":[{"id":29928,"href":"https:\/\/kb.sambapos.com\/en\/wp-json\/wp\/v2\/posts\/9495\/revisions\/29928"}],"wp:attachment":[{"href":"https:\/\/kb.sambapos.com\/en\/wp-json\/wp\/v2\/media?parent=9495"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kb.sambapos.com\/en\/wp-json\/wp\/v2\/categories?post=9495"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kb.sambapos.com\/en\/wp-json\/wp\/v2\/tags?post=9495"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}