View Issue Details

IDProjectCategoryView StatusLast Update
0005269SymmetricDSImprovementpublic2023-10-05 13:07
Reporterelong Assigned Toelong  
Prioritynormal 
Status closedResolutionfixed 
Product Version3.14.0 
Target Version3.14.0Fixed in Version3.14.0 
Summary0005269: Variables of source catalog/schema names for use in target catalog/schema fields in routing
DescriptionAdd variables for use in sym_router configuration of target_catalog_name and source_schema_name:

$(sourceCatalogName) - catalog name from trigger history entry in source database
$(sourceSchemaName) - schema name from trigger history entry in source database

These variables are easier to understand and allow flexible use, such as including other text around the variable. This is preferable to the old method of using the use_source_catalog_schema flag in combination with $(node) variable to clear a field. The $(none) variable is still supported, but it was removed from the documentation to discourage use and avoid confusion.
Tagsrouting

Relationships

related to 0005226 closedemiller SymmetricDS Pro Improve how the router form handles Target Table, Target Catalog, and Target Schema fields 
related to 0006002 closedpmarzullo SymmetricDS Variables of source catalog/schema names for use in target catalog/schema fields in routing 

Activities

There are no notes attached to this issue.

Related Changesets

SymmetricDS: 3.14 5a6ce61a

2022-04-14 20:05:02

admin

Details Diff
0005269: Variables for sourceCatalog/SchemaName Affected Issues
0005269
mod - symmetric-assemble/src/asciidoc/configuration/routers.ad Diff File
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/extract/ColumnsAccordingToTriggerHistory.java Diff File

Issue History

Date Modified Username Field Change
2022-04-14 20:03 elong New Issue
2022-04-14 20:03 elong Status new => assigned
2022-04-14 20:03 elong Assigned To => elong
2022-04-14 20:03 elong Tag Attached: routing
2022-04-14 20:03 elong Relationship added related to 0005226
2022-04-14 20:05 elong Status assigned => resolved
2022-04-14 20:05 elong Resolution open => fixed
2022-04-14 20:05 elong Fixed in Version => 3.14.0
2022-04-26 18:00 admin Changeset attached => SymmetricDS 3.14 5a6ce61a
2022-07-27 18:59 admin Status resolved => closed
2023-10-05 13:07 pmarzullo Relationship added related to 0006002