How Do I: Setup Transactional Replication?
Transactional replication is a feature of SQL Server that replicates committed changes to the publisher database to one or more subscriber databases. Transactional replication is useful when one needs data that is up to date in different locations. In this podcast speaker speaks about how to set up transactional replication. First the publisher is configured, then the distributor, next publications with articles are created, and finally a subscriber is created. The podcast explains making changes to the publisher database and having those changes appear at the subscriber.