170 likes | 279 Views
Distributed Database Management Systems. Lecture # 23. 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.
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