We have a desktop application that uses sql ce 3.5 SP1 - in the past we have always found that we cannot have the data file located on a network drive.
We recently upgraded our development environment to sql ce 3.5 SP2 to facilitate development of synchronisation features. I was surprised to find that we can now open a data file on a network share. With sql ce 3.5 sp2 is it now supported to have the data
file on a network share? I believe we only open one connection to the database at a time.
I have also read with interest the announcement of the release of sql ce 4.0. Can sql ce 4.0 work with data files on a network share, or are there new features in this regard?
We are using Sync Framework 2.1 to allow sync between sql ce databases and also (in due course) between sql ce and sql server databases. I noticed the 4.0 readme indicates "Compact 4.0 does not support data replication with SQL Server using Sync
Framework". Does this mean that if we move to sql ce 4.0 it will not be possible to sync the sql ce 4.0 database with sql server? That would certainly stop us moving to sql ce 4.0.
Thanks for any advice.
Regards,
Tim
View Complete Post