We wish to upgrade our old SambPOS v4 server to a new machine & SambaPOS v5.
Currently we have
Windows 7 64 bit
SQL Server 2012
SambaPOS v4 App 4.1.8 [SQ]
I cannot do a backup of samba from within SambaPOS v4 because backup is not available
SAMBA Market does not have the Database module available
I can do a backup of SambaPOs from SQL Server 2012
It then creates a SambaPOS4.bak file
We are about to Purchase SambaPOS V5
I have installed SambaPOS V5 in trial mode
The new System has SQL Server 2017 express
With Microsoft SQL Server Management Studio 18
Please recommend the best way forward, To bring the new system online with
The old SambaPOS4 Data…
P.S. Restore is easy in SQL Server, but upgrade and database connect to system is
I have just installed SambaPOS v4 on another old Win 7 machine and just had a look at the
Samba Market, the database backup tool is available their, Why would it not be available in the
fully registered version ?
V4 is not supported anymore, compared to V5 and everything that’s available there, V4 is more like a proof of concept than a professional version. You are very unlikely to get any support for V4 here as most of the users haven’t used V4 in a very long time.
V5 has all the tools and few more in SambaMarket already “embedded” into it.
After you restore the database (use a different name) and just change your connection string to that database in V5. Normally it will take it few moments longer to boot because it will be making updates to the database.
Once you are in, you can use Program Settings > Maintenance to Update old Rules and few other things if required.
It was a long time ago I did this and as far as I remember it was pretty much seamless.
Here is the Update…
Old Server Win 7 Pro
Run the Backup in SQL Server 2012 management studio.
With SambaPOS V4
Created the PosServerV4.bak file
I turned on the Backup module in trial mode again in version 4 on the old server.
Pointed the path to the *.bak file location.
then I used winzip to zip the file up as was recommended.
copied both the PosServerV4.bak and the PosServerV4.zip
to the new server.
Win 10 Pro
SQL Server 2019
SQL Server 2018-19 (18.8) management studio.
With SambaPOS V5
Started PosServer V5 activated the backup module in trial mode.
pointed to the file location.
then ran the restore from backup.
Closed SambaPOS and reopened with the normal admin password. (Not 1234)
looking great so far…
Then Checked that its running from the New SQL Server
All Good )
Then installed SambaPOS Version 5
on the old workstation computers with windows 7 that are currently setup to use SambPOS V4.
I ran SambaPOS Version 5 but no matter what i did it could not connect to the POSServer
It kept on saying fix the connection to the DataBase.
I had a spare windows 10 workstation, the moment I installed SambaPOS Version 5
And started SambaPOS Version 5 it detected the SQL data on the network.
Please can anyone recommend a fix ? or an idea as to what could be happening… ?
1.4.2. Make the Connection SambaPOS Database
After setup make SambaPOS MSSQL database connection.
– Management > Settings > Local Settings > Database
– Example Data Path : Data Source=Server; User Id=sa; Password=*******; Database=SambaPOS5;