Summary
In this article, I showed you how to set up transactional replication using SQL Server 2005. We focused on how to configure a distributor, create a publication, and subscribe to the publication. The example used in this article was very simplistic. In the real world, setting up replication will present many challenges, but this overview gives you enough of the general pattern for replication with SQL Server 2005 to get you started.
Future articles in this series will dig deeper into transactional replication. I’ll show you how to maintain and troubleshoot replication and use some of its advanced functionality.