migrate sql experss to sql compact

[spanky]

What are the differences between sql compact  and sql experss? I have seen a higher speed with compact sql. You can migrate data from sql express to sql compact?Thanks

[JohnS]

Have a look here http://forum2.sambapos.org/index.php/topic,386.0.html for some info.
Also here http://forum2.sambapos.org/index.php/topic,244.0.html

A simple way to migrate from SQL Express to Compact SQL is to use the SambaPOS Training Mode http://forum2.sambapos.org/index.php/topic,184.0.html. This will create a Compact SQL file called SambaTrain.sdf in the same location as your SambaSettings.txt file. Rename the file to SambaData2.sdf (for simplicity) and change the data connection string in SambaPOS to point to this file.

[spanky]

What I know is if there is any problem with QSL compact istability or loss of data compared to sql express.

[JohnS]

Compact SQL is designed for single terminal, standalone system. It is high speed due to the lack of data redundancy and networking capabilities that SQL Express has.
So, yes, it is fine for a single terminal and it is stable. I have not had any issues with loss of data.

[spanky]

perfect! thanks Johns

[spanky]

One last question, if I install sql compact in rdp can not connect as the second user via iPad?

[JohnS]

Compact SQL = 1 user only

[spanky]

I tried and it works with multiple users. I will say that problems of instability?

[JohnS]

I tried and it works with multiple users. I will say that problems of instability?

As I have stated in my posts, Compact SQL may work under Terminal Services as you are running instanaces of SambaPOS, so it see it as the local machine, and not a networked computer.

Even if it works, Compact SQL is designed only to run on a single computer and only for a single user. Using it on a Terminal Server may be unstable. Microsoft have not documented Compact SQL very well, and they have also not added sufficent protection to stop you from using it outside of its designed purpose.

Summary - USE AT YOUR OWN RISK in a multiuser environment.