Lost settle button from pos menu

[shailyji]

But it would delete the product list also. I think,
I installed local db

[shailyji]

Any way thanks kendash for your support.
I would try my hands again.
Although it would take time but we have to do it to understand it.

[Jesse]

Yes it would. You can look here on how to export your product list.

How to export and import Menus from one Database to Another

I was using SQL Express 2014 and Microsoft SQL Server Management Studio 2014 for this. I will show you how to use Microsoft SQL Server Management Studio to Export your Menu and Products into a SQL Script so you can use Database Tools to import your entire Menu if you ever need to rebuild your database for some reason or you want to use a non production computer to build a menu and then import it to your production system. For whatever reason this may be useful to you here is a simp…

This is for SQL Express. If you installed LocalDB then look here:

[Resolved] Issue Connecting to the database

The default installation of SQLServer Express will create an Instance called SQLEXPRESS. Installing SQL Server Local DB via SambaPOS installation creates an Instance called (localdb)\V11.0 Installing SQL Server Local DB manually (outside of SambaPOS installations) will by default create an instance called (localdb)\MSSQLLocalDB It is good to keep in mind that an Instance is not the same thing as a Database. For example, my SQLEXPRESS Instance contains 2 Databases with the names [SambaPOS3] a…

This tells you that with Microsoft SQL server Management Studio you can connect to your database using (localdb)\V11.0 as instance name. Once connected you can follow my tutorial above.

If you want more control over the database you should install SQL Express 2014 and have Samba Connect to it using the connection string.

Instructions can be found here on how to set this up:

SQL Express 2014 Installation - SambaPOS4 Database Setup - [BONUS] How to Convert from CE to SQL Express

Microsoft SQL Express 2014 SQL Express 2014 Download Link Versions Available Express 32BIT WoW64\SQLEXPR32_x86_ENU.exe Express 32BIT\SQLEXPR_x86_ENU.exe Express 64BIT\SQLEXPR_x64_ENU.exe ExpressAdv 32BIT\SQLEXPRADV_x86_ENU.exe ExpressAdv 64BIT\SQLEXPRADV_x64_ENU.exe ExpressAndTools 32BIT\SQLEXPRWT_x86_ENU.exe ExpressAndTools 64BIT\SQLEXPRWT_x64_ENU.exe LocalDB 32BIT\SqlLocalDB.msi LocalDB 64BIT\SqlLocalDB.msi - MgmtStudio 32BIT\SQLManagementStudio_x86_ENU.exe - MgmtS…