what is the diffrence between Snap Shot and Transaction
Replication
Answer Posted / 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 |
Post New Answer View All Answers
between cast and convert which function would you prefer and why?
How to delete an existing database user?
How to create a simple user defined function in ms sql server?
What is meant by referential integrity?
What is the use of attributehierarchyvisible ? : sql server analysis services, ssas
Do you know what are the steps to process a single select statement?
What is sub-query in sql server?
What is row-level compre?
Explain few examples of RDBMS?
What are partitioned views?
What are actions, how many types of actions are there, explain with example? : sql server analysis services, ssas
What are rows and columns?
How can I create a report based on a query? : sql server management studio
What is the use of sql profiler in sql server 2012?
How to add additional conditions in SQL?