SP 4 Compact SQL -> SP 5 upgrade path

V5 Question
1

I’m trying to upgrade a SambaPOS 4 Compact SQL install to the latest SambaPOS 5 using MSSQL but haven’t been successful as of yet.

Automigrate doesn’t seem to work as SP 5 doesn’t recognize the SDF file. When I add the SDF file as a connectionstring the startup fails with the following errormsg:

Keyword not supported: ‘multipleactiveresultsets’.

I’ve tried creating a backup file using database tools but when I try to import the zip file into SP 5 I get an error message saying the target database type doesn’t match the source.

So is there anyway to migrate SP4 CE SQL to SP5 MSSQL?

2

Hello @telefunken

You can check these links below.

https://kb.sambapos.com/en/2-2-7-database-upgrading-from-sambapos-v3-and-or-v4-to-v5/

https://kb.sambapos.com/en/2-1-3-b-transferring-data-from-local-db-to-sql-database/

https://kb.sambapos.com/en/2-1-3-a-sql-express-server-setup/

3

Hi,

All those methods concern SQL LocalDB or MSSQL, Compact SQL works a bit differently. As I’ve mentioned:

I’ve devised a workaround using SSMS and will post it shortly.

4

You can’t upgrade compact edition it is impossible. You should rebuild your setup in a fresh v5 sql install

You will more than likely experience issues when trying to migrate that. It is best to rebuild it from a fresh database.

5

Like I’ve said, I already succeeded. I’ll write up a tutorial when I have the time.

1 Like
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):

7

Those didnt do it for me. Either SP just crashes due to data corruption or the tool doesn’t work. The database is at max so those tools probably aren’t designed with that in min. Probably due to them being outdated and a hell for dependencies.

I used this tool with SSMS to export the data. The tool is maintained and updated.