View Revisions: Issue #6690

All RevisionsBack to Issue
Summary 0006690: Send Trigger DDL when sending table schema
Revision 2025-01-07 13:20 by pmarzullo
Description New feature to send Trigger DDL from source platform to the same platform at the target when sending table schema.
This also sends functions that are needed for Postgres trigger implementations.
The triggers that are selected to send are triggers that are not SymmetricDS triggers.

This feature only sends trigger DDL from and to the same platform. For example, trigger DDL from a source platform of Oracle can send the trigger definitions to a target Oracle platform.

This takes the source trigger DDL from the source platform and sends the source trigger DDL to the target platform and executes that DDL on the target platform. If there is a syntax change between the two platforms, there will most likely be a syntax error executing the script at the target platform.

The platforms that this was tested with includes Oracle, SQL Server, MariaDB, MySQL, and Postgres.
Revision 2025-01-06 19:46 by pmarzullo
Description New feature to send Trigger DDL from source platform to the same platform at the target.
This also sends functions that are needed for Postgres trigger implementations.
The triggers that are selected to send are triggers that are not SymmetricDS triggers.

This feature only sends trigger DDL from and to the same platform. For example, trigger DDL from a source platform of Oracle can send the trigger definitions to a target Oracle platform.

This takes the source trigger DDL from the source platform and sends the source trigger DDL to the target platform and executes that DDL on the target platform. If there is a syntax change between the two platforms, there will most likely be a syntax error executing the script at the target platform.