Skip to content
← Customer Feedback for Redgate

Settings and activity

2 results found

  1. When changing a table to a view Schema Compare does not drop table first, and then create view.

    4 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    3 comments  ·  Oracle » Schema Compare  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    An error occurred while saving the comment
    Mike commented  · 

    It appears this sometimes works so the drop must have been ran first in that instance.

    Mike shared this idea  · 

  2. Severity: High Object: <schema>.<table> Title: UnsupportedDatatypeConversion Deployment cannot convert a DATE datatype to a TIMESTAMP(3)

    4 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    1 comment  ·  Oracle » Schema Compare  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    planned  ·  Richard Mitchell responded

    Sounds like this is a bug which is best raised via support@red-gate.com

    From what I can see DATE is equivalent to a TIMESTAMP without any timezone information. Looks like it isn’t one of our automatic conversions currently so we can add some test cases and make it happen.

    An error occurred while saving the comment
    Mike commented  · 

    FYI this is in a 12c database.

    Mike shared this idea  ·