it works! thank you.
now… the problem is… my old data on sambapos all gone…
i try this…
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 here97 - 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 location usually is C:\Users{user}\Documents\SambaPOS4.
4… Check in C:\ProgramData\SAMBAPOS\SambaPOS4 and make sure that SambaSettings.txt file is there.
5… Run import_sql.bat
6… Run SambaPOS. Go to Manage->Settings->Local Settings and make sure the Connection String is Data Source=localhost\SAMBAPOS3; User Id=sa; Password=sambapos; Database=SambaPOS4;
This was designed and tested on Win7.
This is non-destructive to your Compact SQL database, but as always I make no guarantees. Always make a copy of your SamabPOS4.sdf file first.
CE2SQL.zip37 (209.8 KB)
but it didnt work…
also this…
it stuck with an error “sql compact scripting utility has stopped working”