What are the challenges you face when working across database platforms? Take the survey

Data differences after running deployment script

sbahnsbahn Posts: 7
edited March 13, 2015 7:38AM in Data Compare for Oracle
We are evaluating Data Compare for Oracle version

As part of that process we have copied parts of a schema to a previously empty schema using the script generated by Data Compare. However, when running Data Compare afterwards a few rows in a few tables still come up as different (visual inspection indicates/reveals they are identical)

Deleting those row and moving over again shows the same behavior.
Schema Compare shows the tables as identical.
Is this a bug? Any ideas?

Thanks in advance,


  • Options
    Could you give me an example of the data that is reported different but appears the same and the schema for the tables.

    I've been working on issues surrounding TIMESTAMP WITH LOCAL TIME ZONE and if the servers are in different timezones there may be an issue.

    It does sound like a bug, we can carry on discussing it here or you can send an email to support@red-gate.com, which is probably better if you want to give us any confidential information.
    Richard Mitchell
    Project Manager
    Red Gate Software Ltd
Sign In or Register to comment.