Search or browse our knowledge base to find answers to your questions ranging from account questions to troubleshooting error messages. The content is curated and updated by our global Support team
Link to Video Transcript:
When setting up bi-directional Replication - be aware that schema names, table names and column names are very sensitive when it comes to case.
For example, if replicating using Oracle and SQL Server
Oracle table "MYSCHEMA"."TEST"
SQL Server table [myschema].[TEST]
In Task settings
TASK 1 - Oracle to SQL
Metadata Tab - Target Metadata --> myschema
Bidirectional Tab -
Source Schema --> MYSCHEMA
Target Schema --> myschema
Task 2 - SQL to Oracle
Metadata Tab- Target Metadata --> MYSCHEMA
Source Schema --> myschema
Target Schema --> MYSCHEMA
If column names are in different cases ensure these are matched in "Table Settings" and the "Transform Tab".
These are the rules:
If experiencing any of these behaviors, it means the Tasks are not setup correctly: