Does Dbvisit Replicate Support the Replicating of Global Temporary Tables?

Owned by Clive Otten (Unlicensed)
Jan 21, 2020
1 min read

Problem Description

Does Dbvisit Replicate support the replicating of Global Temporary Tables?

Solution

Starting in Dbvisit Replicate 2.7.12, Global Temporary Tables (GTT) are automatically excluded. They were not replicated before but often their creation, and population would slow the MINE (and APPLY) process as it had to process the work and then ignore it. Typically the GTTs are not needed to be replicated. If it is desired to save the GTT data, it is often populated from the GTT to a 'regular' table.

Chris Lawless February 25, 2015 11:28