Planning for Replication Programming

Replication Programming

Replication Programming

Planning for Replication Programming

When planning to program an application used in replication, decide what replication topology you will use, which replication actions need to be performed programmatically, and which actions will be performed using other Microsoft® SQL Server™ 2000 tools.

For the actions that are being controlled programmatically, determine what functionality in your business application will be performed only one time (such as creating the databases, configuring a Publisher, or creating a publication), and what functionality will be performed repeatedly (such as creating subscriptions, synchronizing data between the Publisher and Subscribers, and validating replicated data).

Example

At Northwind Traders, data needs to be published to 200 sales representatives around the world. The sales representatives travel often and will need to use laptop computers to change customer data and add new orders. The changes will then need to be synchronized with the Publisher when the sales representative connects the laptop to the network. To set up each laptop with a subscription to the corporate Northwind database, developers decide to program an application that uses Microsoft ActiveX® replication controls to configure the laptop with a subscription. The sales representatives install and run the application, and are then ready to add new customers and orders, and to modify existing data for their customers.

See Also

Planning for Application Development