Update POS to OWN db first before the server.

Robi Navarro
2019-01-17 13:03

Directly update POS to OwnDB without updating server yet

  1. Add column in branch table
    - localnetworkip = pcname
    - port = 80
  2. Add the Terminal table and the terminal sync table to the server manually
  3. Temporarilly update the version of the server's database to the version that will be used for the POS.
  4. Run Patcher > Install POS
  5. Copy the values from the posreceiptsettings/terminal and possettings tables from the server to to the pos' db
  6. run query: 3_update_terminal_table.sql at pos db
  7. Run POS as serverpos then as owndb to update the server's database
  8. Export posdata from outdated server. make sure to remove the 1st 2 lines of sql
  9. Import posdata to POS as new db, then use Insert Select query to overwrite the updated structure in the POS database
  10. Superadmin - ManualSync sales
  11. Check POS if OR# is updated
  12. Check saleshead, transactioncutoffs, cutoffs
  13. Check server vs pos if equal
  14. Revert the version changed from step 3 in the server's database
Tags: owndb, queries, serverbased, sysops, update
Average rating: 0 (0 Votes)

You can comment this FAQ