Re: Help on synch to SQL server
- From: "Darren Shaffer" <darrenshaffer@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Sun, 31 Jul 2005 18:47:35 -0600
M -
You are mostly correct. The only point in your list that I want to clarify
is that when you "dock your device", synchronization through IIS does
not automatically occur. You initiate merge replication or remote data
access
from SQL CE to SQL Server from your smart-device application's code.
This can occur whenever the device has a network path to IIS, whether
that be through Activesync passthrough, 802.11, GPRS, etc.
Unlike merge replication between SQL Servers where you can use RMO
or an ActiveX control to achieve replication without IIS, SQL CE uses
IIS as the gateway through which replication occurs to provide the best
combination of accessibility in the face of a variety of connectivity
scenarios. It can also be secured with SSL although this is not required
(as is web synch with RMO).
Other than that, it seems you have a good understanding of how to get
started with replication and SQL Server CE. Let us know if you run
into any difficulty.
--
Darren Shaffer
..NET Compact Framework MVP
Principal Architect
Connected Innovation
www.connectedinnovation.com
"M Reilly" <m_reilly@xxxxxxxxxxx> wrote in message
news:dcj238$ehh$1$8300dec7@xxxxxxxxxxxxxxxxxxx
>I have written a program for Pocket PC 2003 using visual studio and a
> access database. Ideally I would like to use Sql CE to synch with a SQL
> Server 2000 database. My development machine is running Windows 2000
> Professional and has PWS, SQL server 2000 development edition and Visual
> studio.net
>
> By reading information on the web it looks like I need to
>
> - Load the SQL Server CE 2.0 Server Tools on a machine that is running
> IIS,
> which loads the SQL Server CE Connectivity Management utility and the SQL
> Server CE Virtual Directory on the IIS server.
>
> - Set up SQL Server as a Publisher/Distributor for replication and a
> snapshot folder defined with the appropriate permissions, and set up a
> database for CE.
>
> - Write an application that uses SQL CE in visual studio. When the code it
> depolyed to the Pocket PC device it should install the application on the
> device as well as SQL CE
>
> - When I dock the portable device is should synch though IIS with the SQL
> server.
>
> Is the above correct, and is IIS needed rather than PWS ? Also, why is IIS
> required and is there not a way to synch directly with SQL server ?
>
> Any help with the above or advice greatfully received.
>
> Thanks in advance,
>
> Mark
>
>
.
- References:
- Help on synch to SQL server
- From: M Reilly
- Help on synch to SQL server
- Prev by Date: Help on synch to SQL server
- Next by Date: RE: Can i use embedded visual c++ 4.0 ?
- Previous by thread: Help on synch to SQL server
- Index(es):
Relevant Pages
|
