SQL script to create SambaPOS5 database from scratch

V5 Question
1

Hello everyone,

I am planning to update my SambaPOS system, and I’ll take that opportunity to rationalize the ressources, better for my electricity bill and easier for my UPS - we experience almost daily power failure.

Right now I have max 4 waitresses working together and 4 computers.

  • Compu 1: Server (DB) + client <-wifi-> RDP on tablet
  • Compu 2: client <-wifi-> RDP on tablet
  • Compu 3: client <-wifi-> RDP on tablet
  • Compu 4: client <-wifi-> RDP on tablet

New system, 1 computer (i7700 + 16 GB) runnig proxmox:

  • 1 LXC container - debian 11 running mssql 2019.
  • 4 Windows 7 Virtual Machines running client.
    that configuration works well and is really low on ressources.

Now, the next step is to install the last SambaPOS5 database onto the mssql 2019 server.
Is there such a sql script available?

Thanks

Marc

2

When properly configured, the SambaPOS desktop application will automatically create the database and populate it with default data. From there you can restore a backup.

3

yes, that was my idea if not script exists.
Installing win10, sql server 2019, installing sambapos, and … finally “copy/paste” SambaPOS5" to mssql 2019 on debian.

4

Gotcha. What version of SambaPOS are you using? I should be able to generate the create scripts for you.

5

The last one, the one of today.
Does sambapos “ask” the location of mssql server during installation? I don’t remember, I don’t think so.

6

5.5.4 then. Give me a few minutes I’ll let you know if I can come up with anything.

7

Actually it’s sambapos setup 556 (don’t know if using same database version as 554)

8

I don’t see 5.5.6 in the releases

image

But I’ll get you the 5.5.4 schema and default data and SambaPOS can update the db if needed.

9

here you go

5.5.4_default_db_scripts.zip (64.3 KB)

10

trying now!
OK, I created a new database SambaPOS5 on mssql on debian and run your script:

The database update succeeded

I’ll now install the latest version of samba pos and try to connect to that database, I’ll let you know, thanks a lot.

11

Latest sambapos is 5.5.6 we released yesterday. No release notes yet.

13

Ok, it turned out that my question was irrelevant.

I don’t need the SambaPOS5 database creation script at all.

Like on a full-windows install, I just need to install Sambapos on one fresh windows, enter and configure the connection string (for the first time), and the next time I start SambaPOS, it will create SambaPOS5 database if it does not exist.
The fact that mssql runs on debian has no impact.

I’ll now dig message server and backup path.

1 Like
14

I just need to install Sambapos on one fresh windows,

I had kind of thought so, but who knows lol

Message server can run on any of your windows clients. I’m not sure if it’ll run under WINE. The backups may be more of a sticky wicket.

When I enter /path/to/somthing in the application it is converted to a full path string. The same happens if I modify the settings file directly:
image

The path is passed to the db engine so it’ll need to be a relative path on the db server.