View Issue Details

IDProjectCategoryView StatusLast Update
0003095SymmetricDSNew Featurepublic2020-04-23 16:55
Reporterelong Assigned Toelong  
Prioritynormal 
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.

Relationships

related to 0004362 closedelong SQL Server 2000 gets Invalid object name 'sys.triggers'. 

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 Affected Issues
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 16:18 elong New Issue
2017-05-05 16:18 elong Status new => assigned
2017-05-05 16:18 elong Assigned To => elong
2017-05-05 16:19 elong Description Updated View Revisions
2017-05-05 18:00 admin Changeset attached => SymmetricDS 3.8 22fdc810
2017-05-11 14:20 elong Status assigned => resolved
2017-05-11 14:20 elong Fixed in Version => 3.8.24
2017-05-11 14:20 elong Resolution open => fixed
2017-05-12 14:21 chenson Status resolved => closed
2020-04-23 16:55 elong Relationship added related to 0004362