Active sync and SQL CE

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

João
Fri Dec 03 03:01:56 CST 2004

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