Re: Oracle goes Free

No, my main concern is the redist rights for the required assemblies.
AFAIK, with SqlCE you can only redistribute System.Data.SqlServerCe.dll
if you are a licensed VS.NET user. This may have changed for SQL Server
2005 Mobile Edition though. I haven't kept up with that, but I'm
picking you'd know the answer. :-)


It has, you also get the rights with SQL Server. I expect this to change and
be more generaous like SSE.

(when its on a device its a little more complicated as it
runs via activesync and it gets entertaining with emulaters etc).

How does ActiveSync come into play? Can SQL/e not be used as a
stand-alone datastore on the CF device? Does it have to be used to
connect to a DB on a PC? Or is ActiveSync simply one way of
synchronizing data between the DB on a PC and one on the CF device
(which can act independantly and completely detached)? And if the
latter, are there other transport channels that can be used (e.g
TCP/IP)?


SQL/e can be used as a standalone store but there is some nice helper stuff
in VS that if you want to connect to the device via active synch you can.
There is an app dev model for SQL Mobile where you never manipulate the
store during development directly. You manipulate a store locally and then
synch schema and data to the device version of the store.

-Euan


.

Relevant Pages

  • Re: Newbie help
    ... think I can probably get what I need using SQL Server (the ... > To efficiently store and retrieve data for your needs, ... You only store changed values (as ...
    (microsoft.public.sqlserver.programming)
  • Re: meta data & full text search
    ... There are more issues (transaction control, change control, audit of ... storing the files in a SQL Server table's column defined with an IMAGE ... if you store the files ... consistency of the database, indices, backup, restore, etc. ...
    (microsoft.public.sqlserver.fulltext)
  • Re: [Error 28035] "Header information is either corrupted .." only with GPRS. Internet works. Why ?
    ... I have some customers who have the mentioned problem when they try to sync using ActiveSync and having Norton AntiVirus active on the PC running ActiveSync. ... I have a SQL Server 2000 SP3 installed on a Windows Server 2003 Small ... using RDA. ... USING ActiveSync + Cable connection ...
    (microsoft.public.sqlserver.ce)
  • Re: Access 2000 - Realtime Development - Should i stick with Access97
    ... if I needed to start using SQL Server to store Tables of an Access 97 front ... would this force the need to upgrade. ... > is because you have support clients who are using later versions. ...
    (microsoft.public.access.modulesdaovba)
  • Re: Unicode and long data type
    ... The SQL Server equivalent is a BigInt that ... can store up to 8 bytes of data. ... Hitchhiker's Guide to Visual Studio and SQL Server ... Everything works except for the Unicode data in the ...
    (microsoft.public.dotnet.framework.adonet)