Trigger difference, but SCO displays none /DMS-36184

jaspernygaardjaspernygaard Posts: 38 Bronze 1
edited January 11, 2019 12:18PM in Schema Compare for Oracle
Hi

We a series of triggers, which exists in both DB, but SCO says there's a difference. When looking in the diff, there's none. Any idea why this is happening?


Tagged:

Answers

  • Eddie DEddie D Posts: 1,805 Rose Gold 5
    Hi
    Thank you for your forum post.

    Difficult to know why the comparison is detecting a difference.  One possibility is a difference in line endings or carriage return line feed.

    If click on the 'Show' drop down box between on the left hand side between the comparison results and the SQL differences view, is the option 'Show PL/SQL difference' available?  If yes, select the option, where you will see hexadecimal data, are there any differences highlighted?

    If the answer is no, can you please increase the minimum logging level to verbose as per this help article and send a copy of the log latest log file generated and a copy of the SCO_Comparison.log to support@red-gate.com  

    Many Thanks
    Eddie
     
    Eddie Davis
    Senior Product Support Engineer
    Redgate Software Ltd
    Email: support@red-gate.com
  • Hi Eddie,

    No such option. I've sent you the log files with verbose logging.
  • For reference, a ticket has been created (127422)
Sign In or Register to comment.