January 2003
Intermediate to advanced
896 pages
19h 58m
English
This chapter has looked at both RDA and merge replication used with SQL Server CE. When designing an application that is to use both SQL Server CE and SQL Server, you have to choose between RDA and merge replication as ways of sharing data between the central database and the smart device application. To help you make this choice, Table 17-21 compares some of the features of each.
Table 17-21. Comparison of RDA and Merge Replication
|
RDA |
Merge Replication |
|---|---|
|
SQL Server 6.5 (Service Pack 5) or later. |
SQL Server 2000 (Service Pack 2) or later. |
|
Relatively simple to set up and secure. |
More complex to set up, and security can be quite difficult because there are more components of the architecture. |
|
Uses optimistic ... |
Read now
Unlock full access