Download
1 / 17
170 likes | 290 Views
In Lecture #23, we focus on the creation and management of Snapshot and Distributor agents in a distributed database management system. We will walk through the setup, emphasizing the establishment of a subscription database on the subscriber server (PESH). Although the agents are created, the snapshot hasn't been executed yet. We demonstrate how to execute the Snapshot Agent to create a snapshot of the publication, including the data and tables. After adding a record to the publication tables, we'll observe the agents execute their scheduled tasks, reflecting changes across the system.
E N D
This activity has created the agents (Snapshot agent and Distributor agent) • Also the subscription database at the subscriber server (PESH in our case) • Agents are created, not worked yet, so no snapshot created at the subscriber
Execute the Snapshot Agent, that will create a snapshot of your publication • See How?
It is there, not only the tables But the data as well
Now add a record in any of the tables in your publication (lets say author) at your publisher (QTA) • We selected this table because…. • After adding the record of Muhammad Suhail of Rawalpindi in the table at QTA, wait for one minute
After one minute, both agents will execute as set in their schedules
