Details
-
Type:
Improvement
-
Status:
Open
-
Priority:
Major
-
Resolution: Unresolved
-
Affects Version/s: 1.5.0
-
Fix Version/s: None
-
Component/s: DB Dialects
-
Labels:None
-
Number of attachments :
Description
The triggers are currently created in the default catalog schema, and they can target a table in a different catalog schema. Some database do not allow this, such as SQL-Server. The triggers should probably live in the same catalog schema as the source table. Or, maybe the user should be allowed to specify where the triggers are created.
The cross catalog and cross schema ability of SymmetricDS is weak and untested. It needs cleaned up, and it needs unit testing.