sql server ce replication

  • Thread starter Thread starter Nathan Franklin
  • Start date Start date
N

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
 
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.
 
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.
Click to expand...

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