what is use of Transactional Replication in sql server?
Transactional replication typically starts with a snapshot of the publication database objects and data. When the initial snapshot is taken, subsequent data changes and schema modifications made at the Publisher are usually delivered to the Subscriber as they occur.
Transactional replication is typically used in server-to-server environments and is appropriate in each of the following cases:
* You want incremental changes to be propagated to Subscribers as they occur.
* The application requires low latency between the time changes are made at the Publisher and the changes arrive at the Subscriber.
* The Publisher has a very high volume of insert, update, and delete activity.
* The Publisher or Subscriber is a non-SQL Server database, such as Oracle.