SymmetricDS

Allow for synchronization of views

Details

  • Type: New Feature New Feature
  • Status: Open Open
  • Priority: Major Major
  • Resolution: Unresolved
  • Affects Version/s: None
  • Fix Version/s: ON RADAR
  • Component/s: Core
  • Labels:
    None
  • Number of attachments :
    0

Description

Some database systems allows triggers on views (like SQL Server). It would be nice to be able to synchronized data using views.

Activity

Hide
Permalink
Chris Henson added a comment -

Design Notes:

  • Add a view_name column to the sym_trigger and sym_trigger_hist tables
  • Add support for looking up a view to the ddlutils library. I'd initially implement getView() for just SQL Server.
  • Update TriggerRouterService and SqlTemplate to attempt to install the trigger on the listed view.
Show
Chris Henson added a comment - Design Notes: Add a view_name column to the sym_trigger and sym_trigger_hist tables Add support for looking up a view to the ddlutils library. I'd initially implement getView() for just SQL Server. Update TriggerRouterService and SqlTemplate to attempt to install the trigger on the listed view.

People

  • Assignee:
    Chris Henson
    Reporter:
    Chris Henson
Vote (1)
Watch (0)

Dates

  • Created:
    Updated: