sql server ce replication

[Nathan Franklin]

Hello guys,

just wandering is replication onlyu possible from pda to computer via IIS
with sql server ce and either mssql or msde??

thanks

cheers

nathan

 

[Lonifasiko]

Replication possible strategies are two: RDA (Remote Data Access) and
Merge Replication. They both work through IIS. The other choice is Web
Services.

This is the actual possible scenario:

SQL Server CE 2.0 - SQL Server 2000
SQL Server CE 2.0 - SQL Server 2005 (all optimizations made for this
new version will not work)
SQL Mobile 2005 - SQL Server 2005
SQL Mobile 2005 - SQL Server 2000 (all optimizations made for this new
version will not work)

Correct me if I'm wrong, but as far as I understand, MSDE can only act
as a subscriber, not as a distributor. That is, you cannot play in a
scenario with SQL Server CE replicating with MSDE.

Regards.

 

[Godzilla]

Correct me if I'm wrong, but as far as I understand, MSDE can only act

as a subscriber, not as a distributor. That is, you cannot play in a
scenario with SQL Server CE replicating with MSDE.

Not true! MSDE can be configured as either publisher, distributor and a
scubscriber....