• State Suggested Answer
  • Replies 1 reply
  • Answers 1 answer
  • Subscribers 19 subscribers
  • Views 325 views
  • Users 0 members are here
Options
Related

I am trying to sync between oracle and sql server with repair and i am getting this error Cannot repair; command only valid if source and all targets are Oracle databases

abu n jaman
4 months ago

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?

  • 0 4 months ago

    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.