How to delete or clear SQL database in V5?

[Jesse]

SambaPOS5 uses localdb or sqlexpress database its not a single file database. You can download Micorsoft SQL Server Management Studio and connect to your SambaPOS instance and delete the database. When SambaPOS restarts it will create a new one.

More information about the database setup can be found here:

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

Microsoft SQL Express 2014 [SQL Express 2014 Download Link][1] 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 - …

Common Database Connection Issues - How to resolve them

This was written by @pauln I am just moving it here so it can help other people. Just in case you are still finding issues I will add the process I used as it highlights all the hotspots where roadblocks can occur. As a “freshman” I had to burn the midnight oil with this as well! Platforms Windows 8.1 - fully updated, Workgroups PC1 - Server ASUS I7 3ghz 16G Ram 27" Touch PC2 - Laptop ASUS I7 2ghc 4G Ram 15.4 Touch Check 1 - Services After install SQL Exp 14 as per tutorials …

How to Upgrade v4 Database to a New V5 Database

How to migrate V4 Database to a New V5 Database using Database Backup Module : REMINDER Always backup your database to a location you know is safe before attempting anything like what is mentioned below. You can temporarily enable V4 database backup module on trial mode to create V4 backup. Step 1 Navigate to Settings > Database Backups > Settings Enable Allow overwriting database files if database names does not match during restore. option Enable Migrate after restoration. …

SambaPOS Database Configuration

In this tutorial I want give some details about database configuration. tl;dr; See Step By Step SQL Server Express Setup document for multi user configuration. Introduction SambaPOS can work in three database modes. Demo mode, single user mode and multi user mode. Demo Mode You don’t need to install a database software just to evaluate SambaPOS. SambaPOS can work with a TXT file to let you understand basic SambaPOS functions. Some features might not work properly in demo mode so if you want…