QMcKay
February 25, 2015, 4:20pm
5
Ok, if I said that, it is because you are running SQL Compact Edition (CE), and yes, it is slow. You can check this by double-clicking the SambaPOS title in the top-left. This will reveal the Title bar, and the last 2 characters indicate the Type of DB you are running. If it says CE, you should definitely upgrade your engine.
You need to download and install SQL Express 2014:
http://www.microsoft.com/en-us/download/details.aspx?id=42299
I recommend the full package for x64: ExpressAdv 64BIT\SQLEXPRADV_x64_ENU.exe
Follow these instructions to install and configure 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
Once you have it installed and configured, you need to convert from CE to SQL:
This collection of scripts will convert a Compact SQL (*.sdf) database to SQL Express 2012 database and update SambaPOS to use the database.
Requirements
1… SambaPOS should be working using the Compact SQL database -> SambaPOS4.sdf
2… Install SQL Express 2012 exactly as documented here - DO NOT follow step 4. Using SQL Express 2012. and do not run SambaPOS after installing SQL Express.
3… Locate SambaPOS4.sdf and place all of the files from the attached ZIP file into this location. The locat…