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