Patent ID: 9582558
Date: 2017-02-28
CPC Classifications: G06F

Claim:
1. A method, comprising: instantiating, by a replication agent, a data definition language (DDL) trigger within a database to capture a DDL event corresponding to a DDL command executed in the database, wherein the DDL trigger analyzes the captured DDL event to retrieve information associated with the DDL event for inserting into a shadow table to store the retrieved information, wherein the inserting causes the retrieved information to be logged in a transaction log; obtaining, by the replication agent, the information associated with the DDL event from the logged information in the transaction log upon detecting the insertion of the retrieved information into the shadow table, wherein the obtained information includes a DDL command text of the executed DDL command; filtering, by the replication agent, the DDL command text associated with the DDL event captured by the DDL trigger based on a type of the executed DDL command, from the obtained information, to determine whether to send the DDL command text to a replicate database for replication; and sending, by the replication agent, the DDL command text to the replicate database for replication responsive to determining that the type of the DDL command permits replication.