ctacke/>
Thu Sep 20 07:30:42 PDT 2007
When I said SQL CE I was thinking SQL Compact Edition. Sure, the file can
be used on either side, and one could pull the entire file and then make
modifications, but that's goinf to be really ugly if the database is live or
if's a few hundred MB in size. The solution is not hard. Create some small
app that takes commands through a socket and sends back results. Use RAPI
to push it to the device and start it. Done.
--
Chris Tacke, Embedded MVP
OpenNETCF Consulting
Managed Code in an Embedded World
www.OpenNETCF.com
<chris-s@mailcity.com> wrote in message
news:1190276066.065347.66930@50g2000hsm.googlegroups.com...
> What about using SQL 2005 Compact Edition, would this provide a
> database that can be utilised by both a desktop and a mobile
> application? I guess you are still stuck with exactly how your desktop
> top app would connect to the actual sdf file tho.
>
> Chris
>
>
> On Sep 19, 1:41 pm, "<ctacke/>" <ctacke[at]opennetcf[dot]com> wrote:
>> You'll have to write or acquire some form of proxy then. RAPI can give
>> you
>> the ability to send commands from the desktop to the device, but it has
>> nothing for SQL CE, so you'll need to write some device-side component
>> that
>> takes in commands and returns results and then attach to it in some way
>> (RAPI would work, but I'd be more inclined to use a socket).
>>
>> --
>>
>> Chris Tacke, Embedded MVP
>> OpenNETCF Consulting
>> Managed Code in an Embedded Worldwww.OpenNETCF.com
>>
>> "Rick" <ad...@thebinarysolution.com> wrote in message
>>
>> news:1190205244.829558.230500@g4g2000hsf.googlegroups.com...
>>
>>
>>
>> > Ok, I think RAPI is exactly what I need. As for SQL merge
>> > replication, I don't think this is it at all. I need to be able to do
>> > complex operations on the database. I'd ideally be able to work with
>> > the database like any other database.
>>
>> > Rick- Hide quoted text -
>>
>> - Show quoted text -
>
>