What is the main difference between snapshot and transactional and merge replication?
does anybody have the specific answer...........
Thanks in advance........
Technology Tips and News
What is the main difference between snapshot and transactional and merge replication?
does anybody have the specific answer...........
Thanks in advance........
Very brief answer just to highlight the difference and get you going:
In Transactional Replication: The changes made to the publisher are applied (Incermentally) on the subscriber(s) on periodic basis or continuous basis depending upon how you configured it. Additionally, changes made to the subscriber can also be applied on the publisher under Transactional Replication with Updatable Subscriber topology
Note: At a minimum, the table must have primary key to be able to become part of Transactional replication topology, this is required to track changes and apply it on the subscriber database
In Snapshot Replication: There is no concept of incremental data, the subscribers are initialized after generating the snapshot and remains as is (Stale) until next time you again re-generate the snapshot and applied it.
Note: It is not mandatory that the tables should have primary key to be a part of Snapshot Replication topology
Please note that this is just a very short explanation to make you understand it conceptually and you can find more information on MSDN/ Technet, few links:
What are the different types of SQL Server replication?
http://www.mssqltips.com/sqlservertip/2402/sql-server-replication-interview-questions/