What is the difference between Push and Pull Subscription in Replication?
Push - A push subscription pushes data from publisher to the subscriber.
Changes can be pushed to subscribers on every transctions or on a scheduled basis.
Pull - A pull subscription requests changes from the Publisher. This allows the subscriber to pull data as needed. This is useful for disconnected machines such as notebook computers that are not always connected and when they connect they can pull the data.
SQL Server Interview Questions · · · ·