[AccessD] SQL Server 2005 Compact Edition

...as I see it, the major hang-up with SQL Server Express is the size of the 
installation and that it runs as a service which complicates user 
installation and maintenance ...SQL Server Compact is "compact" and installs 
as a couple of DLLs ...its upward data compatibility makes it ideal for some 
tradeshow floor and scanner apps that I currently do with third party tools 
...now I can move them to my own design/code and the data will move between 
them with a lot less problems.

William Hindman

----- Original Message ----- 
From: "Gustav Brock" <Gustav at cactus.dk>
To: <accessd at databaseadvisors.com>
Sent: Sunday, March 25, 2007 4:42 AM
Subject: Re: [AccessD] SQL Server 2005 Compact Edition


> Hi Arthur et al
>
> Thanks.
> If "wearing Access glasses" it looks like this one feature is the only 
> important one. On the other hand it seems fair, as it clearly is aimed for 
> single user PDA apps.
>
> /gustav
>
>>>> artful at rogers.com 24-03-2007 15:41 >>>
> I'm with you on that, Stuart. When I first read about its (lack of) 
> features, I was baffled. There actully is one small reason to use it, and 
> it's not much of one: it's data-compatible with its big sister, so you can 
> use DTS or SSIS to easily move data back and forth. Other than that, maybe 
> it's so wannabe-geeks can claim they run SQL Server on their little toys.
>
> A.
>
>
>
> ----- Original Message ----
> From: Stuart McLachlan <stuart at lexacorp.com.pg>
> To: Access Developers discussion and problem solving 
> <accessd at databaseadvisors.com>
> Sent: Saturday, March 24, 2007 5:38:31 AM
> Subject: Re: [AccessD] SQL Server 2005 Compact Edition
>
>
> Just downloaded the documentation "Compact_Express_Comparison.doc".
> Unfortunately, it  doesn't support stored procedures, views, triggers or
> role based security.  I can't see any advantages over using an Access BE
> :-(
>
>
> On 23 Mar 2007 at 20:13, Gustav Brock wrote:
>
>> Hi Jim
>>
>> It is free to download and use.
>> But variety of drivers seems very limited - looks like it's mostly aimed 
>> at
>> dot Net as an embedded database.
>>
>> /gustav
>>
>> >>> accessd at shaw.ca 23-03-2007 20:03 >>>
>> It looks very interesting and no where did I see any indication of 
>> time-out
>> or cost. Am I missing something?
>>
>> Jim
>>
>> -----Original Message-----
>> From: accessd-bounces at databaseadvisors.com
>> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gustav Brock
>> Sent: Friday, March 23, 2007 11:27 AM To: accessd at databaseadvisors.com
>> Subject: [AccessD] SQL Server 2005 Compact Edition
>>
>> Hi all
>>
>> Anyone having any experience or opinion on this:
>>
>>   http://www.microsoft.com/sql/editions/compact/default.mspx
>>
>> Notice the sync tool for Access.
>>
>> /gustav
>
>
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>