What is transactional replication?
Are you preparing for IT certification? With practice questions, study notes, interactive quizzes, tips and technical articles, uCertify PrepKits ensure that you get a solid grasp of core technical concepts to ace your certification exam in first attempt.
What is transactional replication?
Rating:
Transactional replication starts with the snapshot of the Publication database objects and data. The modifications made in the data and in the schema are delivered to the Subscriber database simultaneously. Transactional replication is used in a server-to-server environment in the following conditions:
- When a Publisher or Subscriber is a non-SQL Server database, such as Oracle.
- When incremental changes are to be made at the Subscriber.
- When an application requires low latency.
- When an application requires access to data changes.
- When the Publisher has a high volume of insert, update, or delete operations.
Rating:
Was this information helpful?
Other articles
- What are DTS package templates?
- What is the secedit command?
- What is the SQL Server: General Statistics: User Connections counter?
- What is a temporary stored procedure?
- What is SYS.DM_EXEC_QUERY_STATS DMV?