Re: Active sync and SQL CE

• Previous message: Sapna: "Error installing net cf sp2 cab file programmatically"
• In reply to: Mark brosnan: "Active sync and SQL CE"
• Messages sorted by: [ date ] [ thread ]

Date: Fri, 3 Dec 2004 09:01:56 -0000

IIS is a requirement for either merge replication or RDA. If you only have
ActiveSync to play with take a look at the Data Port line of products
(www.primeworks.pt). These work over ActiveSync to port SQL CE databases to
and from SQL Server 2000 and Access (no IIS needed). The best choice for you
may be to use the Component (C# assembly / C++ DLL) to integrate into your
application. This will allow you to not only specify what tables to import /
export but also what data to import / export on those tables.
If you need help evaluating the tools (30 days), send me an email through
the support "at" primeworks.pt email.

-- 
Joćo Paulo Figueira
Embedded MVP
"Mark brosnan" <anonymous@discussions.microsoft.com> wrote in message 
news:0bc801c4d8f6$7fd868e0$a301280a@phx.gbl...
> Greetings to ALL,
>
> I am trying to develop an application that has sales
> people walking all over the city. They are going to have
> Hand held devices hosting SQL CE.  I have a central SQL
> server that has lot of data in it.
> I need to
> 1. Transfer few table's data in to device.
> 2. The sales people will use UI i make and enter the
> information they collect. I presume that will be stored in
> SQL CE.
> 3. Later part of the day, the sales people will come back
> and sync up the data at the office.
>
> 1. I do not need wireless connectivity and all that stuff.
> My Devices will use a networking card to connect to the
> server that hosts SQL directly.
>
> 2. My client is not willing to install IIS on the machine
> that hosts SQL server. But as far as i have read, merge
> replication and RDA needs IIS.
>
> 3. Client is willing to buy any version of activeSync /
> SQL CE as long as the requirements are met.
>
> Can i not use Active Sync alone to transfer data from
> device which is connected directly to the desktop that is
> having the SQL server.
>
> Please let me know.
>
> Thanks
> Mark 

• Previous message: Sapna: "Error installing net cf sp2 cab file programmatically"
• In reply to: Mark brosnan: "Active sync and SQL CE"
• Messages sorted by: [ date ] [ thread ]