[dba-VB] SQL Server Compact 3.5

Thank you, David,

But for Click-Once is a PITA to have some custom files installed together
with application? (I have many such files).

So, I can just use Click-Once bootstrapping to setup SQL Server CE 3.5 SP1.

Did you try to use MS SQL 2008 R2 databases with SQL Server CE 3.5 SP1, or
SQL Server CE 3.5 SP1 databases are just the ones created and managed within
Visual Studio solutions and then distributed together with such a solution
setup kit? (I have never used SQL Server CE)

Thank you.

--
Shamil
 
-----Original Message-----
From: dba-vb-bounces at databaseadvisors.com
[mailto:dba-vb-bounces at databaseadvisors.com] On Behalf Of David McAfee
Sent: 29 ??????? 2010 ?. 22:01
To: Discussion concerning Visual Basic and related programming issues.
Subject: Re: [dba-VB] SQL Server Compact 3.5

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
>
>
_______________________________________________
dba-VB mailing list
dba-VB at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-vb
http://www.databaseadvisors.com