Interview Questions - SQL Server Replication - What is the difference between Push and Pull Subscription in Replication?

Getting Started with Adobe After Effects - Part 6: Motion Blur


	Interview Questions

This module helps you to share, discuss and learn interview questions and answers of different technologies


	Submit a Question


	Subscribe..

Home · Most Liked · Most Asked · Most Discussed · Sections

SQL Server Replication - What is the difference between Push and Pull Subscription in Replication?

Dec 1 2011 12:12AM by Nirav

Question

What is the difference between Push and Pull Subscription in Replication?

Answer

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.

Read More.. [32134 clicks]

Published under: SQL Server Interview Questions · · · ·

Previous: SQL Server - What is SQL Server replication?
Next: How many non clustered indexes can be created in SQL Server?

Nirav

37 · 5% · 1593

Liked

Asked


Post this to my facebook wall
Tweet this
Like this
I have asked or faced this question during an interview


	Submit

Your Comment

Sign Up or Login to post a comment.

"SQL Server Replication - What is the difference between Push and Pull Subscription in Replication?" rated 5 out of 5 by 3 readers

SQL Server Replication - What is the difference between Push and Pull Subscription in Replication?

Question

Answer

Your Comment