Read Aloud the Text Content

This audio was created by Woord's Text to Speech service by content creators from all around the world.

Text Content or SSML code:

The main components of SQL Server Replication are the following: The Publisher is an SQL Server instance or server that publishes changes made on some tables (articles) by sending the updates to the Distributor. It has a database, which in this case is the Altitude uCI Server database. The Distributor is an SQL Server instance or server that collects changes in the articles from a Publisher and distributes them to the Subscribers. The distributor database, in our architecture, is an internal system database. The Subscriber is an SQL Server instance or server that is receiving the changes made on the Publisher. It can also be at the same server, or at a different one. The Subscription database is the database where the customer report data will be written. In this case, the Reporting database. The publication type used will be "Transactional publication", and the Distributor directly updates the data in the Subscriber database using a "Push subscription".