markjw
March 1, 2022, 4:32pm
6
There are already 2 tutorials on the forum on ways to convert Compact SQL to SQL Express (or LocalDB, which would be the same as still connects in SSMS):
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…
Below is a Step by step guide on how to migrate files from SQL Compact Edition to SQL Server 2012. Very useful if you have configured SQL Express 2012.
For anyone need help configuring SQL Express 2012 for SambaPOS follow the simple steps on below link: http://www.sambapos.org/en/content/installing-sql-express-2012-sambapos-v3
[Creating the migration file]
Locate the file SambaPOS4.sdf file in SambaPOS folder in My Documents. Copy it and paste it on your C:\ drive. The file should be loca…