Book Table of Contents
3/26/2008
Chapter 1 :: Let’s Dive In 15
Introduction to Merge Replication 15
Scenarios 17
Running a Magazine 20
Implementing the Blueprint 24
Create a Domain user 26
Create the Database 32
Rob’s Commentary 42
Chapter 2 :: Configuring the Distributor 43
Chapter Takeaways 43
Create the Snapshot Folder 43
Configure Distribution Wizard 51
Securing the Distributor 66
Disabling a Distributor or Publisher 70
Named Pipes 78
Ongoing Maintenance 79
Rob’s Commentary 80
Chapter 3 :: Configuring the Publisher 82
Chapter Takeaways 82
New Publication Wizard 82
Securing the Publication 116
Named Pipes…Again 130
Ongoing Maintenance 131
Rob’s Commentary 132
Chapter 4 :: Web Synchronization 135
Chapter Takeaways 135
SQL Server 2005 Client Components 135
SQL Server 2005 Service Pack 2 146
SQL Server Compact 3.1 Server Tools 147
Configure Web Synchronization Wizard 154
Configure IIS Properties 168
Test Web Synchronization 171
Rob’s Commentary 178
Chapter 5 :: Coding the Subscriber 181
Chapter Takeaways 181
The SqlCeReplication Object 181
SubscriberConnectionString 184
Publisher Properties 185
Timeout Properties 186
Web Properties 187
Subscriber Properties 187
SqlCeReplication Methods 188
Testing for the Database File 189
Determining the Database File Size 190
Rob’s Commentary 191
In Conclusion… 192