Diff viewer cuts data

Compares and synchronizes Oracle data

Moderators: eddie davis, richardjm, Michael Christofides, neil.anderson

Diff viewer cuts data

Postby ab » Mon Aug 22, 2011 6:39 pm

Hi,

We have recently purchased several licenses for this helpful tool.

It would, however, save a significant effort if the the built-in viewer (column-to-column value) would show more than a few dozen of string characters.

In our use case scenario we have Oracle clobs (containing xml config templates) being compared. A human typically decides whether the difference is to be synchronized or not, based on what the actual differences are. If the delta is beyond what the viewer shows, this quickly becomes a joy-killing labor to open the clobs externally to do a side-by-side, repeat number of records. This quickly kills the joy of using the tool.

Again, we do not need a full blown diff display, just showing full content side-by-side would be great.

Thanks,
Alex.
ab
 
Posts: 2
Joined: Mon Aug 22, 2011 6:27 pm

Postby Tom Harris » Thu Sep 01, 2011 11:17 am

Hi Alex,

I'm sorry to hear that Data Compare for Oracle is proving a little tiresome when it comes to assessing differences in CLOB fields.

If I understand correctly, you are asking if the main data diff view could be modified to show more of the CLOB data, instead of having to click for the pop-up viewer. Is this correct?

It would be hard for us to make that view multi-line, which I think it what you are asking for.

Feel free to post here, or drop me an email tom.harris at redgate.com

Regards, Tom

Tom Harris, Red Gate Software Ltd.
Tom Harris
 
Posts: 308
Joined: Wed Oct 06, 2004 3:45 pm

Postby ab » Thu Sep 01, 2011 9:16 pm

Tom:

Thank you for the response.

I meant the pop-up viewer actually. What I see in either side of the pop-up is a line or two of a multiline document. What we need is a full text display on both sides.

I realize the content may have no line breaks or be platform specific (crlf or lf or no line breaks). In that case a fixed line length should help, I believe.

Thanks again,
Alex.
ab
 
Posts: 2
Joined: Mon Aug 22, 2011 6:27 pm

Postby Tom Harris » Mon Sep 05, 2011 11:31 am

Hi Alex,

this does sound odd. You should be able to maximize the pop up window so that it fills the whole screen. This will then give you a side-by-side diff of the differences between the 2 objects.

Does maximizing the pop-up window not work for you?

Kind regards, Tom

Tom Harris, Red Gate Software
Tom Harris
 
Posts: 308
Joined: Wed Oct 06, 2004 3:45 pm

CLOBS Error

Postby thiagohsp » Mon Dec 19, 2011 1:12 pm

Hi Tom,

I've the same problem with CLOBS fields.. When I open it with diff viewer it cuts its contents (i don't no why). It would be cool if had an option to just show the field with full value, with no comparison.

Thanks!
thiagohsp
 
Posts: 1
Joined: Mon Dec 19, 2011 12:56 pm


Return to Data Compare for Oracle

Who is online

Users browsing this forum: Robert and 1 guest