My database type is wrong?

[Luis_Varsan]

Hi Everyone,

I have an install of SambaPOS 4 running and I cannot seem to figure out my database.

In the taskbar is shows SQ which should be multi-user SQL but my computer has no SQL Server installation in start, etc. I download the Microsoft SQL Server tools and it does not show SQL installed.

It can’t be CE because there is no .sdf file in Documents\SambaPOS4

So how do I figure out what database my system is using and where it is?

[sukasem]

It is localDB SQL Express. So,It is SQL Express but for local Database.
If you want to use multi terminal, you still need to install SQL Express Server Edtion

[Luis_Varsan]

Thank you but how do I go about exporting the DB? It’s not an SDF file… and also I do not see any other way to export it.

[sukasem]

Please use search button (magnifier icon) on the top right. That is very useful.

Here I did that for you.

SambaPOS Database Configuration

You can either use MSSMS (Microsoft SQL Server Management Studio) or use Database Backups tool from Market Place. If you use MSSMS then your Server Name would be (LocalDb)\v11.0 Once connected its as easy as selecting Databases > SambaPOS4 right click it and choose Tasks > Backup Structure of the database for LocalDb might be slightly different I am not sure if it names it SambaPOS4 or not. I should install a localDb version just to check that some day.

[Jesse]

You can upgrade localdb to full SQL express easily by running the SQL express installer and upgrading it.

[Luis_Varsan]

Thanks to you both. I bought the database backup module just in case support this great project and I will try the upgrade.

Also I am going to buy the v5 pro license.

Thanks guys , samba rocks!

[Jesse]

Just so you know the v5 license includes the Database Backup module in fact it includes all previously paid modules.

[Luis_Varsan]

Yes I noticed that but I had already paid the database! The v5 option is interesting, since I love SambaPOS no issues paying some money to help its dev. Thanks again.