View Issue Details

IDProjectCategoryView StatusLast Update
0003095SymmetricDSNew Featurepublic2017-05-12 10:21
ReporterelongAssigned Toelong 
PrioritynormalSeverityminorReproducibilityN/A
Status closedResolutionfixed 
Product Version3.8.24 
Target Version3.8.24Fixed in Version3.8.24 
Summary0003095: Add basic DDL replication
DescriptionAdd a basic feature for DDL (data definition language) replication that captures changes to schema and syncs them to other nodes. Should capture changes to new tables, views, triggers, stored procedures, and functions. Use "S" SQL event to route the change to other nodes on configured group links. When a table is being created, altered, or dropped, the node should call sync triggers.

Allow feature to be enabled/disabled with trigger.capture.ddl.changes parameter. Required to run sync triggers after changing parameter. Will work only on SQL-Server at this time, but Oracle could be added in future.
TagsNo tags attached.

Activities

There are no notes attached to this issue.

Related Changesets

SymmetricDS: 3.8 22fdc810

2017-05-05 12:20:17

admin

Details Diff
0003095: Add basic DDL replication
0003095
mod - symmetric-client/src/main/java/org/jumpmind/symmetric/db/mssql/MsSqlSymmetricDialect.java Diff File
mod - symmetric-client/src/main/java/org/jumpmind/symmetric/db/mssql/MsSqlTriggerTemplate.java Diff File
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/common/ParameterConstants.java Diff File
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/db/AbstractSymmetricDialect.java Diff File
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/db/AbstractTriggerTemplate.java Diff File
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/db/ISymmetricDialect.java Diff File
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/route/ConfigurationChangedDataRouter.java Diff File
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/TriggerRouterService.java Diff File
mod - symmetric-core/src/main/resources/symmetric-default.properties Diff File

Issue History

Date Modified Username Field Change
2017-05-05 12:18 elong New Issue
2017-05-05 12:18 elong Status new => assigned
2017-05-05 12:18 elong Assigned To => elong
2017-05-05 12:19 elong Description Updated View Revisions
2017-05-05 14:00 admin Changeset attached => SymmetricDS 3.8 22fdc810
2017-05-11 10:20 elong Status assigned => resolved
2017-05-11 10:20 elong Fixed in Version => 3.8.24
2017-05-11 10:20 elong Resolution open => fixed
2017-05-12 10:21 chenson Status resolved => closed