[dba-VB] SQL Server Compact 3.5

David McAfee davidmcafee at gmail.com
Fri Oct 29 13:01:22 CDT 2010

I used it on Mobile devices.

I developed a ClickOnce VB.Net Launcher app that our users run to copy the
SDF from the mobile device over to the PC.

The VB app then pulls datasets (invoices) from the SDF using ADO.Net and
passes them to a web service. Different datasets (customer updates,
New "wishlist orders", Item updates) are also returned via the web service and
inserted into the SDF. The SDF is then copied back to the mobile device.

Users of older versions (CF 2.0, 3.0) are also converted to 3.5 on the
fly via my app.

I had to write some custom Bootstrappers to detect if the correct
prequisites were installed.

The prerequisites are:
Windows Installer 3.1
.Net Framework 3.5 SP1
MS ActiveSync 4.5 (if using WinXP)
Windows Mobile Device Center (If Vista/7, 32 bit)
Windows Mobile Device Center x64 (If Vista/7, 64 bit)
SQL Server CE 3.5 SP1 (X86)
SQL Server CE 3.5 SP1 (X64)

I didn't like Click once at first as I thought it was very limited.
After finding out about writing Bootstrappers, I was much more happier with it.

On Fri, Oct 29, 2010 at 2:09 AM, Shamil Salakhetdinov
<shamil at smsconsulting.spb.ru> wrote:
> Hi All --
> Did you work with MS SQL Server 3.5 Compact edition?
> http://www.microsoft.com/sqlserver/2008/en/us/compact.aspx
> Will that work with MS SQL Server 2008 R2 databases?
> How do you distribute your application using MS SQL Server 3.5 Compact
> edition? (Yes, all the info on distrobuting MS SQL Server 3.5 based apps is
> on Internet but I have never worked with it and I hope you have some hints
> to get up&running here ASAP)
> Thank you.
> --
> Shamil
> _______________________________________________
> dba-VB mailing list
> dba-VB at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-vb
> http://www.databaseadvisors.com

More information about the dba-VB mailing list