A remote distributor model can be used when you want subscribers to be configured to use a single MS SQL Server instance to get different publications (centralized distribution). In the local distributor model, a single MS SQL Server instance runs both the Publisher and the Distributor. A distributor database can be considered as the Publisher and the Distributor at once. A distributor acts as a database for storing replicated transactions. There are three main roles in MS SQL database replication: distributor, publisher and subscriber.Ī distributor is an MS SQL database instance configured for collecting transactions from publications and for distributing them to subscribers. For example, you can select only the most critical tables and fields by using filters and replicate only this data. MS SQL Server replication allows you to use filters and select custom entities for replication, which, as a result, reduces traffic, redundancy and amount of data stored in a database replica. This is the final set of entities from the database designated for replication.Ī filter is a set of conditions for an article. Multiple articles can be created for the same object.Ī publication is a logical collection of articles. Articles can be scaled vertically or horizontally by using filters. DISCOVER SOLUTION Terminology Used for MS SQL Server Replicationīefore diving into configuration and setting up MS SQL Server replication, let’s first briefly go over the main terms and the replication models.Īrticles are the basic units to be replicated, such as tables, procedures, functions and views.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |