Toad World® Forums

Missing duplicates in Data Compare

I'm working on merging two oracle databases and are using Toad Data Point to analyse the content in the tabels. In som cases, when the colomn is a varchar colomn, data point can't find the duplicates. I insert two files with snaps from the same table, to show this. As you can see, klassekode A og B i found, bud klassekode 2 and 3 is not found.

Is there a way to get around this problem?

Hi,

problem here is that TDP compare data based on position of data. We expect that key columns are almost same and we don’t do any sophistic join between tables. Because data 2 and 3 are not in same position (or in next row) after we ordering tables then we are not able pair these rows for compare.

I am thinking about one more complicated solution. If you don’t need generate script you can use specific select statement and compare results. You can join your tables in Cross-Connection Query Builder and get results from tables. Then you are able compare these two Grids and see differences. It is not so elegant solution but maybe should help you.

Filip