How can we help you today? How can we help you today?

Trigger difference, but SCO displays none /DMS-36184

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?


jaspernygaard
0

Comments

3 comments

Sort by
  • Eddie D
    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 D
    0
  • jaspernygaard
    Hi Eddie,

    No such option. I've sent you the log files with verbose logging.
    jaspernygaard
    0
  • jaspernygaard
    For reference, a ticket has been created (127422)
    jaspernygaard
    0

Add comment

Please sign in to leave a comment.