I am trying to repair out of sync table between oracle and sql server and i am getting this error. cannot repair; command only valid if source and all targets are Oracle databases. Do you know how to sync source oracle to sql server?
I am trying to repair out of sync table between oracle and sql server and i am getting this error. cannot repair; command only valid if source and all targets are Oracle databases. Do you know how to sync source oracle to sql server?
Hi - as of Version 12 of SharePlex, the compare and repair functions are only available for Oracle and PostgreSQL databases. For SQLServer, you can use TOAD Data Point. You can also look the log files in the ,SharePlex <vardir>log directory and see the SQL that caused the out of sync condition and apply corrections manually.