Welcome to part two of our miniseries on connecting SQL Server CE on the Pocket PC to SQL Server. In last night’s episode, you learned the tale of two SQL Servers that exchanged data with each other via a technology called RDA. Tonight you’re going to learn about another way to skin the same cat with SQL Server merge replication. Long before SQL Server CE was born, big brother SQL Server 7 and 2000 implemented a method of distributing data amongst remote servers called merge replication. Essentially this means that one SQL Server can make the contents of its databases and tables available to other SQL Servers by publishing those objects and the data contained in them. Other SQL Servers subscribe to those publications in order to create replicas of those objects and their data on their own servers. This is a great way to move the data that people need closer to them. One common example of this technology is a branch office that replicates with a home office so that branch users won’t have to run queries over the WAN. Today, SQL Server CE can take advantage of this same technology by subscribing to publications found in SQL Server. The replicated data can be added to, updated, and deleted, and then remerged back into SQL Server. This makes for a powerful alternative to RDA and will certainly help your field agents get their memos merged together in a unified SQL Server database back at headquarters.
KeywordsServer Agent Visual Basic Identity Column Database Engine Radio Button
Unable to display preview. Download preview PDF.