what is the diffrence between Snap Shot and Transaction
Replication
Answers were Sorted based on User's Feedback
Snapshot is the a picture or snapshot of the databse is
taken peridicalloy propgated to the sbuscripber.
it does't invole continuesly.
only read only
transcation replication : This can be used to replication
changes to the database with this any changes made to the
replication data immediately caputred from transcation log
and propogated to the distributor
Is This Answer Correct ? | 6 Yes | 2 No |
Answer / gowtham
In snapshot replication we ccan take the copy of the database
from publisher and put it into the subscriber,here it is in read-only mody it will not allow us to make any modifycations
In Transactional replication it is a oneway commite if we did any modifications in publisher those modifications will be replicated to suscriber (here the log rederagent captures the
changes in suscriber from transactional log and it moves to the distibutor).
Is This Answer Correct ? | 2 Yes | 1 No |
What is a database in ms sql server?
What is a self join in sql server?
What is ms sql server service broker?
What is snapshot replication?
Explain features of analysis services?
What's the maximum size of a row?
What is Files and Filegroups in SQL Server & it's implementation.
What is data compression? : sql server database administration
How to drop an existing table with "drop table" statements in ms sql server?
How can you see what type of locks used?
What are the recovery models for a database?
What Is The Difference Between Primary Key & Super Key