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 |
How can I check if a view exists in a sql server database?
What to perform pattern match with the like operator?
Why truncate is ddl command?
what is bit datatype? : Sql server database administration
How to get a list of columns in a view using "sys.columns" in ms sql server?
Can you explain the disadvantages/limitation of the cursor?
How to create Clustered Primary Key to table?
What is co-related sub query?
How to create new tables with "select ... Into" statements in ms sql server?
Define views.
What is indexing explain it with an example?
Explain cursor as data base object?