Announcement

Collapse
No announcement yet.

comparing SQL from 2 different database vendors

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • comparing SQL from 2 different database vendors

    I am comparing SQL between 2 different Database vendors: Oracle and SQL Anywhere.
    Here is a sample: see attached.
    The left side is Oracle SQL, the right side is SQL Anywhere.
    How do I make a rule that says Oracle datatype "number" is equivalent to SQL Anywhere datatype "integer"?
    Thanks
    Murray
    Attached Files

  • #2
    There are a couple of methods.

    If you have Pro edition, you can go to the Session menu -> Session Settings, Replacements tab, and define "number" = "integer" for this view or a default for all future Text Compare views. This would apply regardless of file type.

    The File Format can be specific to file type, but is defined as Oracle "Number" is Unimportant and SQL "integer" as Unimportant whether they align to each other or to something else; any difference would be Unimportant (although the other side would be Important if it is different, important text).
    http://www.scootersoftware.com/suppo..._unimportantv3
    Aaron P Scooter Software

    Comment

    Working...
    X